Groups > comp.databases.postgresql > #687

Pg_dump makes me nut !

Path	csiph.com!news.swapon.de!aioe.org!.POSTED!not-for-mail
From	DeepThought <ilmio@ilmioserverdiposta.it>
Newsgroups	comp.databases.postgresql
Subject	Pg_dump makes me nut !
Date	Fri, 18 Dec 2015 13:00:15 +0100
Organization	Aioe.org NNTP Server
Lines	27
Message-ID	<n50sgh$a4c$1@speranza.aioe.org> (permalink)
NNTP-Posting-Host	cWMIrjVrZce4JiF+d3VwOQ.user.speranza.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=iso-8859-15; format=flowed
Content-Transfer-Encoding	7bit
X-Complaints-To	abuse@aioe.org
User-Agent	Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.4.0
X-Notice	Filtered by postfilter v. 0.8.2
X-Mozilla-News-Host	news://news.netlab.it:119
Xref	csiph.com comp.databases.postgresql:687

Show key headers only | View raw

Hi guys,

well.. this is a strange problem. I've deeply searched over all forums 
but I've found nothing at all. Thanks in advance 4 answers.

I have a database composed by 3 different schemas: one of them (called 
"notsobigschema" :P ) has a table of about 30Gigs, and with a single 
table of 19Gigs inside. This table is full of LOBs and I don't know why 
part of it seem in pg_toast_$tableoid and part of it in pg_largeobject. 
But this is not the problem.

When I use pg_dump to make a db backup, it takes all memory and swap 
available and kernel kills pg_dump session caused a out of memory 
exception . I have a RAM of about 8Gb  and a pair of swap.
  When I use a *pg_dump -n notsobigschema * , it succeded and finish 
with success.
Obiuvsly, u can say, "schema flag exclude blob from dump". True. But in 
-n schema mode, pg_dump takes all RAM+SWAP too.

So.. HOw can I explain ? DO the biggest table (without LOB ) fit 
perfectly in sum of RAM+SWAP , considering total consumption of memory ?
Have pg_dump a different behaviour in memory managment when manages LOB ?


How may can I limit pg_dump memory consumption to  fit my resources?

Thanks a lot

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar

Thread

Pg_dump makes me nut ! DeepThought <ilmio@ilmioserverdiposta.it> - 2015-12-18 13:00 +0100
  Re: Pg_dump makes me nut ! Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2015-12-18 13:12 +0100
  Re: Pg_dump makes me nut ! Robert Klemme <shortcutter@googlemail.com> - 2015-12-19 21:38 +0100
  Re: Pg_dump makes me nut ! DFS <nospam@dfs.com> - 2017-05-11 07:44 -0400

csiph-web