Re: [HACKERS] Patch to speed up pg_dump

2009-04-01 Thread Vincze, Tamas
Tom Lane wrote: "Vincze, Tamas" writes: +* Note that it may still select BLOBs that have no comment if a pg_description row's objoid +* matches a BLOB's loid, but references an object contained in a different system catalog, ... seems lik

[HACKERS] Patch to speed up pg_dump

2009-04-01 Thread Vincze, Tamas
Hi, We have a database with tens of millions of large objects, none of them with any comments. When running pg_dump it spends several hours looking for BLOB comments, finding none at the end but taxing the server so much that the simplest query takes seconds to complete. The attached patch fixes