Alban Hertroys wrote:
On 3 Jul 2011, at 12:00, Geoffrey Myers wrote:
We have a process that we successfully ran on virtually identical
databases. The process completed fine on a machine with 8 gig of
memory. The process fails when run on another machine that has 16
gig of memory with the following error:
out of memory for query result
You didn't mention what client you're using, but could it possibly be
the client that's running out of memory? The fact that it's happening
in the query result seems to point to the client.
Perl.
Another thing you might want to check: Does the second server have at
least as much shared memory configured in the kernel as the first
has?
I was thinking that might be the issue. They have the same amount of
share memory configured, but the server that had the error, has 8
postmasters running, whereas the other server only has one.
Alban Hertroys
-- Screwing up is an excellent way to attach something to the
ceiling.
!DSPAM:1272,4e109ddd12091486111017!
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
