Path: csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail From: Dimitri Fontaine 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: References: 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 Hi, Please consider asking on the pgsql-general mailing list instead: http://www.postgresql.org/list/pgsql-general/ Regards, DeepThought 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