Re: Best practice to get performance

From: Ivan Voras <ivoras(at)freebsd(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Best practice to get performance
Date: 2010-11-19 22:04:25
Message-ID: ic6s99$mtn$2@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/19/10 15:49, Andy Colson wrote:

> unlogged will only help insert/update performance. Lookup tables sound
> readonly for a majority of time. (I'm assuming lots of reads and every
> once and a while updates). I doubt that unlogged tables would speed up
> lookup tables.

Are FreeBSD's temp tables still storage-backed? (i.e. are there
memory-backed temp tables)?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2010-11-19 22:14:50 Re: Best practice to get performance
Previous Message Mage 2010-11-19 22:00:47 Re: subquery join order by