Taming large datasets in PostgreSQL: archiving and retention without the pain
PostgreSQL databases tend to grow silently. One day, you notice queries slowing down, backups taking forever, and no one remembering what is in that 500 GB log…
Фильтры
Keeping Postgres tidy with partitioning
If you are in doubt whether partitioning is a useful tool with this one example I’m hoping you won’t wonder any further. Let’s assume we have some…
Upgrading inheritance partitioning made easy.
An alternative way to upgrade to PostgreSQL 10 native partitioning using ALTER TABLEs and PLPGSQL. Today’s post is a bit spontaneous, because a few days ago I…