Re: pg_dump: NOTICE: ShmemAlloc: out of memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brad Paul <bradpaul(dot)a(dot)with(at)long(dot)tail(dot)bdp-optics(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump: NOTICE: ShmemAlloc: out of memory
Date: 2003-04-11 20:31:52
Message-ID: 13486.1050093112@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Brad Paul <bradpaul(dot)a(dot)with(at)long(dot)tail(dot)bdp-optics(dot)com> writes:
> I'm trying to dump a database called stocks. I did:
> pg_dump stocks > stocks.sql
> pg_dump: NOTICE: ShmemAlloc: out of memory pg_dump: Attempt to lock table
> "slab" failed. ERROR: LockAcquire: holder table out of memory

> This database has 3478 tables.

You probably need to increase max_locks_per_transaction. Or better,
rethink your schema. Thousands of tiny tables is usually a bad idea
compared to a smaller number of (properly indexed) tables.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ismaila Kane 2003-04-11 20:35:03 Re: pgsql data file location
Previous Message Tom Lane 2003-04-11 20:24:48 Re: How can I get a column INT4 to be UNSIGNED ?