Re: [PERFORM] Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE

2004-12-23 Thread Tom Lane
Pailloncy Jean-Gerard <[EMAIL PROTECTED]> writes: > I think I have a test case for 7.4.2 Try the attached patch. It looked to me like there were some smaller leaks going on during COPY and CREATE INDEX, which I will look into later --- but this seems to be the problem for VACUUM FULL.

Re: [PERFORM] Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE

2004-12-22 Thread Tom Lane
Pailloncy Jean-Gerard <[EMAIL PROTECTED]> writes: > I think I have a test case for 7.4.2 Can you send me the test data (off-list)? regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [PERFORM] Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE

2004-12-22 Thread Pailloncy Jean-Gerard
I think I have a test case for 7.4.2 So I have a 3 millions of rows table "metadata" with a tsearch2 index. I had memory leak in "vacuum full verbose analyze" I drop the index, run "vacuum full verbose analyze", recreate the index and re-run "vacuum full verbose analyze". The I run my script to i