Re: idea: global temp tables

Hi,

Le 27 avr. 09 à 23:32, A.M. a écrit :
> When will postgresql offer "global" temporary tables with data which
> are shared among sessions? Such tables are great for transient data
> such as web session data where writing to the WAL is a waste. (On DB
> startup, the tables would simply be empty.) We're currently stuck
> with the memcached plugin which makes it impossible to use database
> constructs such as foreign keys against the temporary data.


If using 8.3 you can SET LOCAL synchronous_commit TO off; for web
session management transactions, it'll skip the WAL fsync'ing, which
is already a good start.

HTH,
--
dim