-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Erik Jones wrote: > On Aug 24, 2007, at 11:46 AM, Tom Lane wrote: > >> Jeff Amiel <becauseimjeff@xxxxxxxxx> writes: >>> Aug 22 18:08:24 db-1 postgres[16452]: [ID 748848 >>> local0.warning] [6-1] 2007-08-22 18:08:24 CDT ERROR: >>> out of memory. >>> Aug 22 18:08:24 db-1 postgres[16452]: [ID 748848 >>> local0.warning] [6-2] 2007-08-22 18:08:24 CDT >>> DETAIL: Failed on request of size 536870910. >> >>> What I found interesting is that It's ALWAYS the same >>> size....536870910 >> >>> maintenance_work_mem = 512MB # min 1MB >> >> Apparently this maintenance_work_mem setting is higher than your system >> can reliably provide. Knock it back a bit. >> >> regards, tom lane > > I'm not so sure. In my case, the request size was only 256MB and we > maintain about 10 - 11 GB free of our 16 GB of memory (2GB > shared_buffers, 42MB work_mem, and 256 MB maintenance_work_mem). The > toast table that was involved in the error was pretty small and I was > able to successfully vacuum it myself virtually instantly. However, in > my case, this (so far) being a one time error I don't have much more > data to contribute. We constantly monitor and graph our system's I/O, > CPU, and memory usage and scan our logs for errors so if anything else > comes up I'll be sure to share. We are actually diagnosing a similar problem on this end, where we get a failure at 1920... I am currently trying to get some DEBUG output. Sincerely, 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ > - -- === 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 iD8DBQFGzx/gATb/zqfZUUQRAg10AJ9bmIUZ8V99vVCDZfWH05PWckf49QCfa4ta G1daeagQY2CMUR1QDMtuXTQ= =HxG3 -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
