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: | 296 |
Nodes: | 16 (3 / 13) |
Uptime: | 51:33:43 |
Calls: | 6,650 |
Calls today: | 2 |
Files: | 12,200 |
Messages: | 5,330,306 |