Re: Temporary Tables and Web Application

From: Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Temporary Tables and Web Application
Date: 2008-06-06 07:23:02
Message-ID: 4848E5D6.8050302@batory.org.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hermann Muster 2008-06-06 09:32:34 Re: Accessing other databases with DBLink when leaving user/password empty
Previous Message Tomasz Ostrowski 2008-06-06 06:59:56 Re: Full vacuum really slowing query down