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.