On Tue, 2004-12-21 at 16:31 +0700, Amrit Angsusingh wrote: > I used postgresql 7.3.2-1 with RH 9 on a mechine of 2 Xeon 3.0 Ghz and ram > of 4 Gb. Since 1 1/2 yr. when I started to use the database server after > optimizing the postgresql.conf everything went fine until a couple of > weeks ago , my database grew up to 3.5 Gb and there were more than 140 > concurent connections. ... > shared_buffers = 250000 this is much higher than usually adviced on this list. try to reduce this to 25000 > effective_cache_size = 5000 and increase this instead, to say, 50000
gnari ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
