Re: [GENERAL] Large aggregate query running out of memory in ExecutorState

2007-03-02 Thread Tom Lane
Casey Duncan <[EMAIL PROTECTED]> writes: > I have some nightly statisics queries that runs against a view which > unions several large tables. Recently one of these queries started > running into out of memory errors. This is on postgresql 8.1.8 > running on 32-bit Debian Linux. What have yo

[GENERAL] Large aggregate query running out of memory in ExecutorState

2007-03-02 Thread Casey Duncan
I have some nightly statisics queries that runs against a view which unions several large tables. Recently one of these queries started running into out of memory errors. This is on postgresql 8.1.8 running on 32-bit Debian Linux. Here is the error in the log including the query (excluding