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?
How may can I limit pg_dump memory consumption to fit my resources?
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.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 491 |
Nodes: | 16 (2 / 14) |
Uptime: | 94:51:57 |
Calls: | 9,679 |
Files: | 13,725 |
Messages: | 6,174,314 |