Re: Temporary Tables and Web Application - Mailing list pgsql-general

From Tomasz Ostrowski
Subject Re: Temporary Tables and Web Application
Date
Msg-id 4848E5D6.8050302@batory.org.pl
Whole thread Raw
In response to Re: Temporary Tables and Web Application  ("Brent Wood" <b.wood@niwa.co.nz>)
Responses Re: Temporary Tables and Web Application  (Tim Tassonis <timtas@cubic.ch>)
List pgsql-general
On 2008-06-06 07:25, Brent Wood wrote:

> Would "real" tables in a tablespace defined on a ramdisk meet this
> need?

Bad idea. This would mean an unusable database after a restart.

> You could also mount a tablespace on a physical disk with a
> filesystem which has delayed/deferred writes to disk

Not a vary good idea. This could mean an unusable database after a crash
or power failure.

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
                                                      Winnie the Pooh

pgsql-general by date:

Previous
From: Tomasz Ostrowski
Date:
Subject: Re: Full vacuum really slowing query down
Next
From: Hermann Muster
Date:
Subject: Re: Accessing other databases with DBLink when leaving user/password empty