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