Re: idea: global temp tables

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Apr 27, 2009, at 5:39 PM, Dimitri Fontaine wrote:

> 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.

That's pretty close, but it's not table specific and wouldn't let us
to reliably mix transient data changes with real data changes.

Cheers,
M
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.10 (Darwin)

iEYEARECAAYFAkn2KNcACgkQqVAj6JpR7t4OrQCgpU9K3FzG2LWWyM245vUaop1G
ZMIAn379RDewxKUmCsZsWLo8KdWAYGIs
=kHl5
-----END PGP SIGNATURE-----