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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
