RE: Does the work made by vaccum in the current pass is lost when interrupted?

Thank you Michael for your suggestion, I will reduce vacuum_cost_delay and increasing vacuum_cost_limit to speedup vacuum. But the I/O system is very solicitated on PROD system and I do not want to impact end user performance. If aggressive cost_delay and vacuum_cost_limit slow down significative

Does the work made by vaccum in the current pass is lost when interrupted?

the next vacuum. I guess that the visibility map is updated only at the end of each pass. My best regards Thank you Jean-Marc Lessard Administrateur de base de données / Database Administrator [cid:image001.jpg@01D69D5F.64DB0EA0] Ultra Electronics Forensic Technology Inc. T +1 514 489 4247 x4164

pgstattuple extension - Can pgstattuple_approx support toast tables?

alternative but it does not accept toast tables. It can be run on pg_largeobject which is very similar to the toast table structures. Why pgstattuple_approx() cannot be run on toast tables? Regards, Jean-Marc Lessard Administrateur de base de donn?es / Database Administrator [cid:Grey_159x30_4bbe7521

RE: pg_dump out of memory for large table with LOB

sion and only 3 pieces can fit in a block. Can we change the LOBLKSIZE to 2000 bytes to fit 4 rows in a block as follow? #define LOBLKSIZE 2000 Must the LOBLKSIZE be a power-of-2? Is there any optimization expecting a power-of-2 value? Thank you. Jean-Marc Lessard Administrateur de

RE: pg_dump out of memory for large table with LOB

s it means, no incurs cost to generate the out of line toast, but that a > copy of the bytea is still made for the new line? I bench mark it as follow: UPDATE table SET mod_tim=mod_tim; The relpages of the table doubled, but the relpages of the toast table did not changed. Jean-Marc Lessard A

RE: pg_dump out of memory for large table with LOB

f-line values change. Does it means, no incurs cost to generate the out of line toast, but that a copy of the bytea is still made for the new line? Jean-Marc Lessard Administrateur de base de données / Database Administrator Ultra Electronics Forensic Technology Inc. T +1 514 489 4247 x4164 www.ult

RE: pg_dump out of memory for large table with LOB

le? So LOB will be more suitable for frequently updated table where the binary data rarely change. Jean-Marc Lessard Administrateur de base de données / Database Administrator Ultra Electronics Forensic Technology Inc. T +1 514 489 4247 x4164 www.ultra-forensictechnology.com<http://www.ultra-forensictechnology.com>

pg_dump out of memory for large table with LOB

curity enabled for table "ibisl1.signatures" pg_dump: reading policies for table "ibisl1.signatures" pg_dump: reading large objects pg_dump: reading dependency data pg_dump: saving encoding = UTF8 pg_dump: saving standard_conforming_strings = on out of memory Jean-Marc Lessard