Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group