Is this what you're looking for? If you need something different, just
specify. Remember this is WinXP. This is all of the memory output from
perfmon measured every 15 seconds. The query runs for about 20-30
minutes before the error message comes up. This shows the entire time
it took to run the query and one measurement after the error came up.
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Qingqing Zhou
Sent: Wednesday, June 14, 2006 11:13 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Out of memory error in 8.1.0 Win32
""Relyea, Mike"" <Mike.Relyea@xerox.com> wrote
> I've just started receiving an out of memory error with my most
complex
> query.
Can you post the memory usage log after the error the server reports?
Regards,
Qingqing
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend