On Wed, Aug 22, 2007 at 07:07:20PM +0200, Christian Schröder wrote: > These are the current settings from the server configuration: > shared_buffers = 3GB this is *way* to much. i would suggest lowering it to 1gig *at most*. > max memory size (kbytes, -m) 3441565 this looks like too close to shared_buffers. again - lower it. > The machine is a linux box with 4 GB memory running PostgreSQL 8.2.4. is it by any chance i386 architecture? depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
