Re: Out of Memory - 8.2.4

-----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(at)myemma(dot)com
> 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-----