Re: pg_dump out of memory for large table with LOB - Mailing list pgsql-general

From Ron
Subject Re: pg_dump out of memory for large table with LOB
Date
Msg-id 31706cdf-97bd-7a7b-47cc-2e90309725b6@gmail.com
Whole thread Raw
In response to RE: pg_dump out of memory for large table with LOB  (Jean-Marc Lessard <Jean-Marc.Lessard@ultra-ft.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Default Privilege Table ANY ROLE
Next
From: Nicolas Paris
Date:
Subject: Re: Default Privilege Table ANY ROLE