benchmarking Archives - 2ndQuadrant

Posts

TPC-H performance since PostgreSQL 8.3

October 22, 2020/0 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

In the first part of this blog series, I’ve presented a couple of benchmark results showing how PostgreSQL OLTP performance changed since 8.3, released in 2008. In this part I plan to do the same thing but for analytical / BI queries, processing large amounts of data. There’s a number of industry benchmarks for testing […]

OLTP performance since PostgreSQL 8.3

October 8, 2020/4 Comments/in PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

A couple years ago (at the pgconf.eu 2014 in Madrid) I presented a talk called “Performance Archaeology” which showed how performance changed in recent PostgreSQL releases. I did that talk as I think the long-term view is interesting and may give us insights that may be very valuable. For people who actually work on PostgreSQL […]

Benchmark on a Parallel Processing Monster!

February 28, 2017/8 Comments/in David's PlanetPostgreSQL /by David Rowley

Last year I wrote about a benchmark which I performed on the Parallel Aggregate feature that I worked on for PostgreSQL 9.6. I was pretty excited to see this code finally ship in September last year, however something stood out on the release announcement that I didn’t quite understand: Scale Up with Parallel Query Version 9.6 […]

Posts

Support & Services

Products

Postgres Learning Center

About Us