PostgreSQL12 brings dramatic improvements in partitioning in PostgreSQL databases. Read all about in Kirk’s in-depth blog. | Continue reading
With every new release of PostgreSQL, there are a range of performance enhancements. Some are system-wide and affect every user, but most are highly specific to a certain use case. In this post, I am going to briefly highlight three improvements in PG12 that speed up certain oper … | Continue reading
Many improvements have been made to partitioning in PostgreSQL 12. Here's some benchmark results so you can see what's been done. | Continue reading
Declarative partitioning got some attention in the PostgreSQL 12 release, with some very handy features. There has been some pretty dramatic improvement in partition selection (especially when selecting from a few partitions out of a large set), referential integrity improvements … | Continue reading
Declarations, Input, arithmetic, functions, constants and usage of PostgreSQL Interval, Date, Timestamp and Time data types. Thank you, Chicago. | Continue reading
Computed columns in PostgreSQL 12 are here, but still have a ways to go. | Continue reading
Legal documents = SCARY!! Except when it comes to PostgreSQL. If only all databases were as simple, legally, as PostgreSQL. | Continue reading