2ndQuadrant | PostgreSQL Blog
1,223 FOLLOWERS
2ndQuadrant is global experts in PostgreSQL support, training, development, migration and consultancy.
2ndQuadrant | PostgreSQL Blog
3y ago
This post continues from my report on Random Numbers. I have begun working on a random data generator so I want to run some tests to see whether different random number generators actually impact the overall performance of a data generator. Let’s say we want to create random data for a table with 17 columns ..read more
2ndQuadrant | PostgreSQL Blog
3y ago
With the release yesterday of PostgreSQL 13, now is perhaps a good time to talk about when and how it should be deployed. We often get questions at such times like "When should I upgrade?" and "Should I switch my new planned deployment to the new release?" The first thing to consider is this: you ..read more
2ndQuadrant | PostgreSQL Blog
3y ago
Postgres BDR has seen exciting growth in the financial services and telecommunication industries. These industries present a new set of challenges that push the limits of Postgres Synchronous COMMIT features for Highly Available clusters. This webinar explored the Postgres Synchronous COMMIT deployment models and discussed the limitations associated with them. The webinar also introduced a ..read more
2ndQuadrant | PostgreSQL Blog
3y ago
Welcome to the third – and last – part of this blog series, exploring how the PostgreSQL performance evolved over the years. The first part looked at OLTP workloads, represented by pgbench tests. The second part looked at analytical / BI queries, using a subset of the traditional TPC-H benchmark (essentially a portion of the ..read more
2ndQuadrant | PostgreSQL Blog
3y ago
I’ve been slowly working on developing open source database systems performance testing tools from scratch. One of the components of this toolset is a data generator that can build a dataset to be loaded into a database. I’ll need a random number generator for that and these are the requirements that I think are most ..read more
2ndQuadrant | PostgreSQL Blog
3y ago
Postgres is a great database engine but what are the best ways to load data into it? In order to explore Bulk Data Loading in PostgreSQL in detail, 2ndQuadrant arranged a live webinar, “Best Practices for Bulk Data Loading in PostgreSQL", which explored the answers to some of the most common questions related to bulk data loading ..read more
2ndQuadrant | PostgreSQL Blog
3y ago
This webinar on PostgreSQL Partitioning (originally conducted in 2019), is now available to watch on our YouTube channel. This webinar gave an overview of PostgreSQL partitioning and how it plays a key role in sensible management and improved performance with very large databases. Particular use cases were also highlighted, along with taking a look at ..read more
2ndQuadrant | PostgreSQL Blog
3y ago
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 ..read more
2ndQuadrant | PostgreSQL Blog
3y ago
OmniDB is an effective workspace to tame and optimize PostgreSQL clusters, with easy and secure access to data, system health, and customizations. And all this, unified in the flavor of your preference: web-browser solution with access to multiple DBAs or a single ready-to-use desktop app installed on your working station. In order to explore OmniDB ..read more
2ndQuadrant | PostgreSQL Blog
3y ago
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 ..read more