Re: scale up (postgresql vs mssql) - Mailing list pgsql-performance

From Claudio Freire
Subject Re: scale up (postgresql vs mssql)
Date
Msg-id CAGTBQpamMUQZGAeVEykun7t+uz86Pr9_crvgCvJNMUFmiTtJUg@mail.gmail.com
Whole thread Raw
In response to Re: scale up (postgresql vs mssql)  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-performance
On Fri, Apr 13, 2012 at 2:49 PM, Steve Crawford
<scrawford@pinpointresearch.com> wrote:
> Well, the fact that temporary and unlogged cannot be simultaneously
> specified *is* documented:
>
> CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT
> EXISTS ] table_name
>
> But it would probably be worth adding a note under the description of
> temporary tables that they are, in fact, unlogged.

Yes, it was quite subtle, but you're right. I should've read the
syntax more closely.

pgsql-performance by date:

Previous
From: Steve Crawford
Date:
Subject: Re: scale up (postgresql vs mssql)
Next
From: Tom Lane
Date:
Subject: Re: Slow fulltext query plan