Postgres Pro
Downloads
Home   >   mailing lists

out of shared memory - find temporary tables - Mailing list pgsql-sql

From Sabin Coanda
Subject out of shared memory - find temporary tables
Date
Msg-id iie1ik$18ol$1@news.hub.org
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: creationw
Date:
Subject: How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version 8.1?
Next
From: "Sabin Coanda"
Date:
Subject: how control update rows