out of shared memory - find temporary tables

From: "Sabin Coanda" <s(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: out of shared memory - find temporary tables
Date: 2011-01-31 08:32:59
Message-ID: ii5s87$p99$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there,

I got "out of shared memory" error.

Searching on postgresql forums, I found this it occurs probably because of
intensive use of temporary tables in one transaction.

I'm locking in pg_locks table, and I found some rows with the following
modes: "ShareLock", "AccessExclusiveLock", "ExclusiveLock",
"AccessShareLock", and "RowExclusiveLock" with many counts (especially
"AccessExclusiveLock" and "AccessShareLock"), but the oid and relname is
empty. I suppose there are related to some temporary tables.

How can I find what are the storage procedures which create these temporary
tables in my code ?

TIA,
Sabin

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Buckler 2011-01-31 13:41:56 Autovacuum Issues?
Previous Message Alban Hertroys 2011-01-31 07:53:06 Re: Adding more space, and a vacuum question.