slow pg_dump with bytea

From: Janning Vygen <vygen(at)kicktipp(dot)de>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: slow pg_dump with bytea
Date: 2023-10-20 10:26:06
Message-ID: 1325559b-6a40-411d-a1ab-1e1162e3722b@kicktipp.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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

Responses

Browse pgsql-bugs by date

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