No announcement yet.

Some Initial PostgreSQL 11.0 Database Benchmarks

  • Filter
  • Time
  • Show
Clear All
new posts

  • Some Initial PostgreSQL 11.0 Database Benchmarks

    Phoronix: Some Initial PostgreSQL 11.0 Database Benchmarks

    Among other software releases, yesterday brought the debut of the PostgreSQL 11.0 database server. Given it has possible performance enhancements and the new (non-default) LLVM-based just-in-time compilation ability, I decided to run some benchmarks on the powerful Dell PowerEdge EPYC 2P server...

  • #2
    Thanks for fixing the charts on iOS, appreciated.


    • #3
      Originally posted by anarki2 View Post
      Thanks for fixing the charts on iOS, appreciated.
      Was a simple fix once hearing it and then getting access to an iOS device for a few minutes (the Chrome simulator didn't behave the same).
      Michael Larabel


      • #4
        I'm interested about benchmark on low end ARM, jit improve drastically the performance?
        Developer of Ultracopier/Supercopier and of the game CatchChallenger


        • #5
          JIT won't improve every query, and probably won't even be run on most queries (unless your database architecture sucks). It may help computationally-expensive queries (which the optimizer recognizes as such) which have to perform calculations to return values and/or determine which values to return. Think business analytics or other potentially complicated searches with qualifiers that can't be effectively indexed. On the plus side these can also be some of the longest to run, and provide the greatest perceived end-user delay, so it may provide a benefit disproportionate to the benchmark results. The same applies to queries which can be parallelized; several new operations can be parallel in this release (for some DBAs, parallel CREATE INDEX will be huge).


          • #6

            What's the (RAID) setup of the 20 SSDs?

            - Gilboa
            DEV: Intel S2600C0, 2xE5-2658V2, 32GB, 6x2TB, GTX1080, F32, Dell UP3216Q 4K.
            SRV: Intel S2400GP2, 2xE5-2448L, 96GB, 6x2TB, GTX550, F32, Dell U2711.
            WIN: Gigabyte B85M-HD3, E3-1245V3, 32GB, 5x1TB, GTX980, Win10Pro.
            BAK: Asus H110M-K, i5-6500, 16GB, 3x1TB + 128GB-SSD, F32.
            LAP: ASUS Strix GL502V, i7-6700HQ, 32GB, 1TB+256GB, 1070M, F31.