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

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

2008-10-28 Thread Tom Darci
Hi All, 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 largest of which have 4 million or so row