Postgres Pro
Downloads
Home   >   mailing lists

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

From Steve Crawford
Subject Re: scale up (postgresql vs mssql)
Date
Msg-id 4F885604.6080404@pinpointresearch.com
Whole thread Raw
In response to Re: scale up (postgresql vs mssql)  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: scale up (postgresql vs mssql)
List pgsql-performance
Tree view 
On 04/13/2012 08:04 AM, Claudio Freire wrote:
> ...You might want to try unlogged temp tables, which more
> closely resemble mssql temp tables.
>
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.

Cheers,
Steve

pgsql-performance by date:

Previous
From: xlash
Date:
Subject: PostgreSQL - Help Optimizing performance - full text search on Heroku
Next
From: Claudio Freire
Date:
Subject: Re: scale up (postgresql vs mssql)