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
How is this possible?
The databases are almost identical. By that I mean, the database that
the process completed properly is a dump of the database from the
machine where it failed. There is about a week's more data in the
database where the process failed. The whole database only takes up
about 13 gig of disk space.
Any clues would be appreciated.
One other note that is bothering me. There is no reference in the log
regarding the out of memory error. Should that not also show up in the
associated database log?
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
