Month: October 2017
Best of PostgreSQL 10 for the Developer
2 weeks ago a new PostgreSQL major version with the number 10 was released (note the new numbering scheme!). I already covered my favorite parts from the official release notes from a DBA’s point of view already here, so also take a look there, if you are interested in the operational side as well. In […]
Best of PostgreSQL 10 for the DBA
Last week a new PostgreSQL major version with the number 10 was released! Announcement, release notes and the “What’s new” overview can be found from here, here and here – it’s highly recommended reading, so check them out. As usual there have been already quite some blog postings covering all the new stuff, but I […]
Verifying PostgreSQL replicas
BY Kaarel Moppel – Although Postgres is a great all-around product that can’t be beaten in price-performance ratio, there’s one area where things could be a bit better. That’s in the validation of replicas, or maybe even more widely, all clusters. What’s the problem? After building a new replica there’s actually no way to tell […]
Distributed aggregates / aggregate pushdown in PostgreSQL
PostgreSQL 10 will provide end users with countless new features. One of those features is related to “Foreign Data Wrappers” and is generally known as “aggregate pushdown”. To be honest: This stuff is one of my favorite new features of PostgreSQL 10 and therefore it might be worth, sharing this piece information with a broader […]