Re: slow pg_dump with bytea

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Janning Vygen <vygen(at)kicktipp(dot)de>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: slow pg_dump with bytea
Date: 2023-10-20 12:51:30
Message-ID: b425b90d7f8ecf0b5cf32b7dbba720e548508e81.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, 2023-10-20 at 14:08 +0200, Janning Vygen wrote:
> Anyhow, for me it seems odd that you can dump in a fraction of time
> compared to the default settings. With the solution in the link you have
> both: speed and compression. Which seems to be offered by pg_dump -Z
> option too, acording to the level yu set. But it isn't.

Who says that the only goal of pg_dump is speed?

Like I said, specialized compression software is way better than PostgreSQL's
built-in "pglz".

Yours,
Laurenz Albe

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2023-10-20 13:18:19 Re: slow pg_dump with bytea
Previous Message Janning Vygen 2023-10-20 12:08:17 Re: slow pg_dump with bytea