Postgres Pro
Downloads
Home   >   mailing lists

Re: Best practice to get performance - Mailing list pgsql-general

From Ivan Voras
Subject Re: Best practice to get performance
Date
Msg-id ic6s99$mtn$2@dough.gmane.org
Whole thread Raw
In response to Re: Best practice to get performance  (Andy Colson <andy@squeakycode.net>)
Responses Re: Best practice to get performance  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
Tree view 
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)?

pgsql-general by date:

Previous
From: Mage
Date:
Subject: Re: subquery join order by
Next
From: Andy Colson
Date:
Subject: Re: Best practice to get performance