Re: [GENERAL] getting our bearings on "out of memory. failed on request of size..."

2008-10-28 Thread Tom Darci
Thanks Tom, The "n" has always been small, like 20, or 4 or 32 (these numbers are from memory, not written down), but the one we ran into today was large: 67108864. I will head to the EXPLAIN, as well as to getting the memory dump from the log. Regards, -Tom ---

Re: [GENERAL] getting our bearings on "out of memory. failed on request of size..."

2008-10-28 Thread Tom Lane
Tom Darci <[EMAIL PROTECTED]> writes: >Our PG server is serving up 50 databases or so (with identical > schemas), and the largest one of those has started giving us "out of > memory. failed on request of size n" errors in many places. This is a > 9 GB database with 100+ tables, the larges