pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump out of memory
2+ messages / 2 participants
[nested] [flat]
* pg_dump out of memory
@ 2012-10-17 17:07 Neil Morgan <N.A.Morgan@brighton.ac.uk>
0 siblings, 1 reply; 2+ messages in thread
From: Neil Morgan @ 2012-10-17 17:07 UTC (permalink / raw)
To: pgsql-admin
Dear All,
I am running a PostgreSQL 8.3 server (not my choice, would prefer 9.1) but I am experiencing memory issues when using pg_dump.
I have looked on the forums for memory issues, and can say that the data is not corrupt.
We are running a VM with RHEL6, 4GB RAM, 2CPU and 80GB HDD
Does anyone have any ideas please?
pg_type_typname_nsp_index: 3072 total in 2 blocks; 1600 free (2 chunks); 1472 used
pg_operator_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
pg_amop_opr_fam_index: 3072 total in 2 blocks; 1600 free (2 chunks); 1472 used
pg_proc_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
pg_opfamily_am_name_nsp_index: 3072 total in 2 blocks; 1624 free (3 chunks); 1448 used
pg_ts_template_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
MdSmgr: 24576 total in 2 blocks; 6528 free (0 chunks); 18048 used
LOCALLOCK hash: 122880 total in 4 blocks; 38128 free (13 chunks); 84752 used
Timezones: 53584 total in 2 blocks; 3744 free (0 chunks); 49840 used
ErrorContext: 8192 total in 1 blocks; 8160 free (4 chunks); 32 used
ERROR: out of memory
DETAIL: Failed on request of size 1073741823.
Regards,
Neil Morgan PGCert MSc MPhil
IT Services
University of Brighton
Watts 137
Lewes Road
Brighton
BN2 4GJ
01273 643930
___________________________________________________________
This email has been scanned by MessageLabs' Email Security
System on behalf of the University of Brighton.
For more information see http://www.brighton.ac.uk/is/spam/
___________________________________________________________
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_dump out of memory
@ 2012-10-17 17:57 Tom Lane <tgl@sss.pgh.pa.us>
parent: Neil Morgan <N.A.Morgan@brighton.ac.uk>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2012-10-17 17:57 UTC (permalink / raw)
To: Neil Morgan <N.A.Morgan@brighton.ac.uk>; +Cc: pgsql-admin
Neil Morgan <N.A.Morgan@brighton.ac.uk> writes:
> I am running a PostgreSQL 8.3 server (not my choice, would prefer 9.1) but I am experiencing memory issues when using pg_dump.
8.3.what?
> Does anyone have any ideas please?
For starters, turn on log_statements so you can see what query is
triggering this. It'd be even better if you can get a stack trace
from the point of the errfinish call.
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-10-17 17:57 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-10-17 17:07 pg_dump out of memory Neil Morgan <N.A.Morgan@brighton.ac.uk>
2012-10-17 17:57 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox