Announcement

Collapse
No announcement yet.

Benchmarks: PostgreSQL 10 Performance Is Looking Good

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #11
    Personally this is my graal: https://www.phoronix.com/scan.php?pa...JIT-PostgreSQL
    Developer of Ultracopier/CatchChallenger and CEO of Confiared

    Comment


    • #12
      Originally posted by uid313 View Post
      Have anyone here used the JSON functionality in Postgres?
      Is it useful? Is it awesome? Do you love it? Or is it cumbersome, and boring?
      Good question!


      Originally posted by alpha_one_x86 View Post
      Well, being a Julia Programming Language enthusiast I need to say that LLVM is an incredible tool! Even within databases it can be useful.

      Comment


      • #13
        Originally posted by uid313 View Post
        Have anyone here used the JSON functionality in Postgres?
        Is it useful? Is it awesome? Do you love it? Or is it cumbersome, and boring?
        YES, the indexing is awesome, querying is a little bit verbose, update have to be done on the whole data.

        Code:
        {
            "name": "andrei",
            "devices": [
              {"kind":"laptop", "kernel":"linux", "name":"lenovo XYZ"},
              {"kind":"smartphone","kernel":"linux", "name":"lg XYZ"}
            ]
        }
        To select device data:

        Code:
        select b.value from table a, jsonb_array_elements(a.column ->'devices')
        where column ->> 'name' = 'andrei'
        But you can query it without needing to unnest the data:

        Code:
        select * from table
        where column @> '{"devices":[{"kind":"laptop"}]}'
        Last edited by andrei_me; 21 May 2017, 10:33 AM.

        Comment


        • #14
          Originally posted by mark_ View Post
          ah and (lol?) cute little computer for that benchmark. How about using something like a HPE ProLiant DL380 Gen9 or so?
          I'm sure Michael would appreciate it if you provided a server like that.

          Comment


          • #15
            Originally posted by Michael View Post

            If only I had one of those....
            Drop me an email. I might be able to spare some CPU/IO cycles on my DL380G9/560G9 machines.

            - Gilboa
            oVirt-HV1: Intel S2600C0, 2xE5-2658V2, 128GB, 8x2TB, 4x480GB SSD, GTX1080 (to-VM), Dell U3219Q, U2415, U2412M.
            oVirt-HV2: Intel S2400GP2, 2xE5-2448L, 120GB, 8x2TB, 4x480GB SSD, GTX730 (to-VM).
            oVirt-HV3: Gigabyte B85M-HD3, E3-1245V3, 32GB, 4x1TB, 2x480GB SSD, GTX980 (to-VM).
            Devel-2: Asus H110M-K, i5-6500, 16GB, 3x1TB + 128GB-SSD, F33.

            Comment

            Working...
            X