Re: [HACKERS] Performance bug in DO blocks

2011-03-27 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Tue, Jan 18, 2011 at 1:46 PM, Tom Lane t...@sss.pgh.pa.us wrote: I just noticed that if you execute the same DO command over and over within a session, it gets slower and slower.  And if you keep it up you'll notice the backend's RAM consumption

Re: [HACKERS] Performance bug in DO blocks

2011-03-26 Thread Robert Haas
On Tue, Jan 18, 2011 at 1:46 PM, Tom Lane t...@sss.pgh.pa.us wrote: I just noticed that if you execute the same DO command over and over within a session, it gets slower and slower.  And if you keep it up you'll notice the backend's RAM consumption bloating too.  The cause appears to be that

[HACKERS] Performance bug in DO blocks

2011-01-18 Thread Tom Lane
I just noticed that if you execute the same DO command over and over within a session, it gets slower and slower. And if you keep it up you'll notice the backend's RAM consumption bloating too. The cause appears to be that we leak the cached plans created for any SQL statements or expressions