Re: Reasonable Configuration

On 7 Sep 2003 at 10:42, Alex wrote:

> Hi,
> the postgres configuration file is somewhat confusing to me and I could
> not find a good tutorial on how to configure the db.
>
> I have a single and dual processor machine, 1GB of memory.
> The database is a couple of GB, about 10Million records.
> The system runs batch jobs that can be quite heave. Users connect via
> Tomcat.
>
> What would be reasonable figures for
>
> - shared_buffers
> - wall_buffere3s
> - sort_mem
> - vacuum_mem
> - effective_chachesize
>
> these are the ones that come into my mind.

Check http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

HTH

Bye
 Shridhar

--
Either one of us, by himself, is expendable.  Both of us are not.        -- Kirk,
"The Devil in the Dark", stardate 3196.1