Postgres Pro
Downloads
Home   >   mailing lists

Re: RAM-only temporary tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: RAM-only temporary tables
Date
Msg-id 12155.1226436097@sss.pgh.pa.us
Whole thread Raw
In response to Re: RAM-only temporary tables  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: RAM-only temporary tables  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Tree view 
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> What's happening is that there is simply so many temporary tables in 
> pg_class that when the new backend tries to clear them with 
> RemoveTempRelations, it runs out of lock space.

What happened to the original owner of the tables?  It must have had
locks on all those tables ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: RAM-only temporary tables
Next
From: Greg Stark
Date:
Subject: Re: failed test float8 on mingw