From: | "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: idea: global temp tables |
Date: | 2009-04-27 21:51:16 |
Message-ID: | 2E8BFBEB-9B84-4178-9D67-64A7B11CBE26@themactionfaction.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2009-04-27 22:01:40 | Re: idea: global temp tables |
Previous Message | Kevin Grittner | 2009-04-27 21:46:13 | Re: idea: global temp tables |