[SQL] out of shared memory - find temporary tables - 02-03-2011 , 04:52 AM
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 ?
Sent via pgsql-sql mailing list (pgsql-sql (AT) postgresql (DOT) org)
To make changes to your subscription: