Re: pg_dump out of memory for large table with LOB

[Ron <ronljohnsonjr@xxxxxxxxx>]

On 11/14/2018 11:14 AM, Jean-Marc Lessard wrote:

Adrien Nayrat wrote:
> With 17 million LO, it could eat lot of memory ;)
Yes it does.

I did several tests and here are my observations.

First memory settings are:
shared_buffers = 3GB
work_mem = 32Mb
maintenance_work_mem = 1GB
effective_cache_size = 9MB
bytea_output = 'escape'

Why escape instead of hex?

--
Angular momentum makes the world go 'round.