out of shared memory - find temporary tables

From: "Sabin Coanda" <s(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-sql(at)postgresql(dot)org
Subject: out of shared memory - find temporary tables
Date: 2011-02-03 10:52:57
Message-ID: iie1ik$18ol$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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-sql by date

  From Date Subject
Next Message Sabin Coanda 2011-02-03 11:01:21 how control update rows
Previous Message Florian Weimer 2011-02-03 09:10:19 Transaction-specific global variable