-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Erik Jones wrote: > > On Aug 27, 2007, at 12:15 PM, Martijn van Oosterhout wrote: > >> On Mon, Aug 27, 2007 at 09:12:17AM -0700, Jeff Amiel wrote: >>> Tracking for last few days. >>> Does not appear to happen when little or no user >>> activity (like Saturday) I don't know if that rules >>> out autovacuum or not (if no update threshholds are >>> reached, no vacuuming will take place anyway) >> >> I don't think I've seen it so far this thread, but what are your memory >> overcommit settings and allocated swap? At least on Linux you would >> need a significant chunk of swap to be able to work with that much >> memory, even with overcommit off. Check the rules for your system. >> >> Another thing I havn't seen mentioned: you appear to be on a 32-bit >> architecture and with 2GB shared_buffers you've lost half your address >> space on that alone. Perhaps you simply don't have enough contiguous >> address space to alloc 512MB. > > The X4600 runs with 64-bit Dual Opterons. The machine we are tracking this problem on is also 64bit. Joshua D. Drake > > Erik Jones > > Software Developer | Emma® > erik@xxxxxxxxxx > 800.595.4401 or 615.292.5888 > 615.292.0777 (fax) > > Emma helps organizations everywhere communicate & market in style. > Visit us online at http://www.myemma.com > > > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFG0xomATb/zqfZUUQRAnfUAJ4jQhMV9vEqL8I7zyT59qo0vhbxuACeLH9d +PpbVOWYxMkrNC/+V4meHSs= =DK8s -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
