Postgres Pro
Downloads
Home   >   mailing lists

slow pg_dump with bytea - Mailing list pgsql-bugs

From Janning Vygen
Subject slow pg_dump with bytea
Date
Msg-id 1325559b-6a40-411d-a1ab-1e1162e3722b@kicktipp.de
Whole thread Raw
Responses Re: slow pg_dump with bytea  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: slow pg_dump with bytea  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-bugs
Tree view 
I don't know if the PG developers are aware of this:

https://serverfault.com/questions/1081642/postgresql-13-speed-up-pg-dump-to-5-minutes-instead-of-70-minutes 


But this question is quite famous and many users like the solution.
So maybe you can fix it by changing the pg_dump process to not compress 
any bytea data.

regards
Janning

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18163: Catcache entry invalidation might be missed when toast processed inside CatalogCacheCreateEntry
Next
From: Alexander Lakhin
Date:
Subject: Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used