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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Qingqing Zhou Sent: Wednesday, June 14, 2006 11:13 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] Out of memory error in 8.1.0 Win32 ""Relyea, Mike"" <Mike.Relyea@xxxxxxxxx> 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
Attachment:
Memory_000005.zip
Description: Memory_000005.zip
