Groups > comp.databases.postgresql > #688

Re: Pg_dump makes me nut !

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From	Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Newsgroups	comp.databases.postgresql
Subject	Re: Pg_dump makes me nut !
Date	Fri, 18 Dec 2015 13:12:23 +0100
Organization	A noiseless patient Spider
Lines	36
Message-ID	<m237v0ez14.fsf@2ndQuadrant.fr> (permalink)
References	<n50sgh$a4c$1@speranza.aioe.org>
Mime-Version	1.0
Content-Type	text/plain
Injection-Info	mx02.eternal-september.org; posting-host="d82aa4f1883ab7155c995516303c9b46"; logging-data="26062"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+k5k0w5nY3LDrwj/bkU9KH"
User-Agent	Gnus/5.13001 (Ma Gnus v0.10) Emacs/24.5 (darwin)
Cancel-Lock	sha1:2ZfFSKXnkAqroSDDsytK5p63mEU= sha1:GrvCWRXTioQeqNz7UbNCO8qmGdw=
Xref	csiph.com comp.databases.postgresql:688

Show key headers only | View raw

Hi,

Please consider asking on the pgsql-general mailing list instead:

  http://www.postgresql.org/list/pgsql-general/

Regards,

DeepThought <ilmio@ilmioserverdiposta.it> writes:
> 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?

-- 
Dimitri Fontaine
PostgreSQL DBA, Architecte

Back to comp.databases.postgresql | Previous | Next — Previous in thread | 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