-----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-----
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
