A while ago, I wrote about the performance impact of query parameter data types. Recently I encountered a similar […]
Migration cost assessment - Find out about conducting an assessment using the free Oracle-to-PostgreSQL migration tool, the CYBERTEC Migrator
What is pg_dump compression? pg_dump is a PostgreSQL utility for backing up a local or remote PostgreSQL database. It creates […]
While the term faceting may sound foreign to you, you almost certainly have run into it in your adventures online. […]
What is GRANT VACUUM, ANALYZE? PostgreSQL uses table VACUUM and ANALYZE commands to optimize the database. The VACUUM command reclaims […]
When partitioning in PostgreSQL, it's not obvious how to find the location of data afterwards. Here's some great partition tips and tricks.
Public schema default permissions changed in PostgreSQL 15 - it might hurt you during application deployment. Here's what to do.
For detailed query performance analysis, you need EXPLAIN (ANALYZE, BUFFERS) output for an SQL statement. With a parameterized statement, […]
In my article that reviles OR, I showed how in certain cases, it is possible to rewrite OR in […]
How do you index in a data warehouse? See the advantages and disadvantages of btree (AKA B-tree) and BRIN indexes in PostgreSQL.
How to upgrade current library versions such as GEOS or GDAL in PostGIS - use the latest stunning spatial features. Upgrade GEOS with Ubuntu.
Recently, a customer asked me why a bulk load into a PostgreSQL table kept slowing down as time went […]
