Skip site navigation (1) Skip section navigation (2)

Re: Number of tables

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Craig James <craig_james(at)emolecules(dot)com>,fabio(dot)lafarcioli(at)molinoalimonti(dot)com,pgsql-performance(at)postgresql(dot)org
Subject: Re: Number of tables
Date: 2009-08-21 00:38:55
Message-ID: 20090821003854.GT6261@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-performance
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.

In response to

Responses

pgsql-performance by date

Next:From: Greg StarkDate: 2009-08-21 00:53:54
Subject: Re: Number of tables
Previous:From: Greg StarkDate: 2009-08-20 23:52:50
Subject: Re: Number of tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group