Re: [PERFORM] vacuum full seems to hang on very small table

2006-04-04 Thread Simon Riggs
On Tue, 2006-04-04 at 08:59 -0600, Dan Harris wrote: > I have a table with 1 live row that I found has 115000 dead rows in it ( > from a testing run ). I'm trying to VACUUM FULL the table and it has > run for over 18 hours without completion. Considering the hardware on > this box and the fact

Re: [PERFORM] vacuum full seems to hang on very small table

2006-04-04 Thread Brad Nicholson
Dan Harris wrote: > I have a table with 1 live row that I found has 115000 dead rows in it ( > from a testing run ). I'm trying to VACUUM FULL the table and it has > run for over 18 hours without completion. Considering the hardware on > this box and the fact that performance seems reasonable in

[PERFORM] vacuum full seems to hang on very small table

2006-04-04 Thread Dan Harris
I have a table with 1 live row that I found has 115000 dead rows in it ( from a testing run ). I'm trying to VACUUM FULL the table and it has run for over 18 hours without completion. Considering the hardware on this box and the fact that performance seems reasonable in all other aspects, I'm