"Kevin Grittner" <[EMAIL PROTECTED]> writes:
>     PortalHeapMemory: 1620992 total in 200 blocks; 5856 free (8 chunks); 
> 1615136 used
>       ExecutorState: 2787288448 total in 364 blocks; 328 free (5 chunks); 
> 2787288120 used

Ouch.  We have created a memory leak someplace, but it's hard to tell
where from this info.  Can you boil this down into a self-contained test
case?  I doubt it depends at all on the specific data, so the table &
view definitions plus some dummy data would probably be enough to
reproduce it.

Is this a 32-bit or 64-bit build?  Also, does the leak still occur if
you just run the query as-is rather than EXPLAIN ANALYZE it?

                        regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to