Re: scale up (postgresql vs mssql)

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Claudio Freire <klaussfreire(at)gmail(dot)com>
Cc: Eyal Wilde <eyal(at)impactsoft(dot)co(dot)il>, pgsql-performance(at)postgresql(dot)org
Subject: Re: scale up (postgresql vs mssql)
Date: 2012-04-13 16:36:20
Message-ID: 4F885604.6080404@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2012-04-13 16:43:50 Re: scale up (postgresql vs mssql)
Previous Message xlash 2012-04-13 16:14:47 PostgreSQL - Help Optimizing performance - full text search on Heroku