Greg Stark wrote:
> It would be nice to have a solution to that where you could create
> lightweight temporary objects which belong to an "application session"
> which can be picked up by a different database connection each go
> around.
It would be useful:
CREATE SCHEMA session1234 UNLOGGED
CREATE TABLE hitlist ( ... );
Each table in the "session1234" schema would not be WAL-logged, and
would be automatically dropped on crash recovery (actually the whole
schema would be). But while the server is live it behaves like a
regular schema/table and can be seen by all backends (i.e. not temp)
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.