Re: Reading data in bulk - help?

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Chris Huston <chuston(at)bangjafwac(dot)com>
Cc: josh(at)agliodbs(dot)com, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Reading data in bulk - help?
Date: 2003-09-10 09:01:07
Message-ID: Pine.LNX.4.44.0309101052540.14280-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mindaugas Riauba 2003-09-10 10:21:55 Re: Need advice about triggers
Previous Message Gregory S. Williamson 2003-09-10 07:40:45 Re: Hardware recommendations to scale to silly load