PostgreSQL
Archiving data as fast as possible
In a recent article here we’ve been talking about how do do Batch Updates in a very efficient way, using the Writable CTE features available in PostgreSQL 9.1. I …
tag
Catalogs
10 posts
Projects
Automated Setup for pgloader
Another day, another migration from MySQL to PostgreSQL… or at least that’s how it feels sometimes. This time again I’ve been using some quite old …
PostgreSQL
Next month partitions
When you do partition your tables monthly, then comes the question of when to create next partitions. I tend to create them just the week before next month and I have …
PostgreSQL
Tables and Views dependencies
Let’s say you need to ALTER TABLE foo ALTER COLUMN bar TYPE bigint;, and PostgreSQL is helpfully telling you that no you can’t because such and such views …
PostgreSQL
Editing constants in constraints
We’re using constants in some constraints here, for example in cases where several servers are replicating to the same federating one: each origin server has his …
PostgreSQL
Querying the Catalog to plan an upgrade
Some user on IRC was reading the releases notes in order to plan for a minor upgrade of his 8.3.3 installation, and was puzzled about potential needs for rebuilding GIST …
PostgreSQL
Partitioning: relation size per “group”
This time, we are trying to figure out where is the bulk of the data on disk. The trick is that we’re using DDL partitioning, but we want a “nice” view of size per …
PostgreSQL
Finding orphaned sequences
This time we’re having a database where sequences were used, but not systematically as a default value of a given column. It’s mainly an historic bad idea, …
PostgreSQL
Resetting sequences. All of them, please!
So, after restoring a production dump with intermediate filtering, none of our sequences were set to the right value. I could have tried to review the process of …
PostgreSQL
Controling HOT usage in 8.3
As it happens, I’ve got some environments where I want to make sure HOT ( aka Heap Only Tuples) is in use. Because we’re doing so much updates a second that I …