Re: Reading data in bulk - help? - Mailing list pgsql-performance

From Dennis Bjorklund
Subject Re: Reading data in bulk - help?
Date
Msg-id Pine.LNX.4.44.0309101052540.14280-100000@zigo.dhs.org
Whole thread Raw
In response to Re: Reading data in bulk - help?  (Chris Huston <chuston@bangjafwac.com>)
List pgsql-performance
On Wed, 10 Sep 2003, Chris Huston wrote:

> Sometime before then I need to figure out how to cut the fetch times
> from the now 200ms to something like 10ms.

You didn't say anything about Joshs first point of adjusting
postgresql.conf to match your machine. Settings like effective_cache_size
you almost always want to increase from the default setting, also shared
memory.

--
/Dennis


pgsql-performance by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: Re: Hardware recommendations to scale to silly load
Next
From: "Mindaugas Riauba"
Date:
Subject: Re: Need advice about triggers