"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