Re: scale up (postgresql vs mssql)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Apr 13, 2012 at 1:36 PM, Steve Crawford
<scrawford@xxxxxxxxxxxxxxxxxxxx> wrote:
>>
> 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[0] have to mention it. Especially due to the
error condition. Right?

[0] http://www.postgresql.org/docs/9.1/static/sql-createtable.html

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux