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





--
Sent via pgsql-sql mailing list (pgsql-sql (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql