pgtoolkit
pgtoolkit copied to clipboard
grayhemp
Tools for PostgreSQL maintenance
Hello There is a table, on the table to create a unique constraint with the options "initially deferred". When processing the table with the option reindex, the constraint reset option...
it seems that if postgresql needs to acquire several locks, it does that in OID order. which causes deadlock if pgcompactor's index gets OID less than existing one's. this is...
In process of migration to PG 9.6 we notice strange behavior of pgcompact - it cant clean any page on any bloated table. We are seeing logs like this: ```...
We are looking to use this tool for an AWS DB, but the highest privilege RDS user anyone has cannot perform certain commands / access certain tables (especially pgtoast): ```...
Useful for e.g. resource consumption configuration. Example: `./pgcompact --dbname pgbench --session-param vacuum_cost_delay=10 `
После reindex concurrency исчезает атрибут 'CLUSTER ON' индекса, которым приходится пользоваться в силу того, что pgcompacor зачем-то выбирает произвольное поле для Update By. Как правильно использовать утилиту ?
Since `pgcompact` is used as a database maintenance tool, you usually have a limited time when you can do maintenance (e.g. when there is less db activity), so it would...
Hi, I have following error for a few tables: ``` Mon Sep 8 09:31:12 2014 zabbix, partitions.history_p2014_06_16 INFO Vacuum initial: 20512 pages left, duration 1.794 seconds. Mon Sep 8 09:31:12...
