Re: New VACUUM FULL
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Cc: Jeff Davis <pgsql@j-davis.com>, Simon Riggs <simon@2ndQuadrant.com>, Alvaro Herrera <alvherre@commandprompt.com>, pgsql-hackers@postgresql.org
Date: 2009-12-07T06:26:35Z
Lists: pgsql-hackers
Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes: > I added regression tests for database-wide vacuums and check changes > of relfilenodes in those commands. > ... > BTW, I needed to add ORDER BY cluase in select_views test. I didn't modify > tests in select_views at all, but database-wide vacuum moves tuples in > select_views test. I think the fix should be reasonable becausae unsorted > result set is always unstable in regression test. You should take those out again; if I am the committer I certainly will. Such a test will guarantee complete instability of every other regression test, and it's not worth it. regards, tom lane