On Fri, Apr 13, 2012 at 1:36 PM, Steve Crawford
> If they are permanent tables used for temporary storage then making them
> unlogged may be beneficial. But actual temporary tables *are* unlogged and
> attempting to create an unlogged temporary table will raise an error.
Interesting, yes, I was wondering why PG didn't make temp tables
unlogged by default.
Then, I guess, the docs have to mention it. Especially due to the
error condition. Right?
In response to
pgsql-performance by date
|Next:||From: Tomas Vondra||Date: 2012-04-13 17:09:10|
|Subject: Re: PostgreSQL - Help Optimizing performance - full text
search on Heroku|
|Previous:||From: Steve Crawford||Date: 2012-04-13 16:36:20|
|Subject: Re: scale up (postgresql vs mssql)|