[PERFORM] Vacuum full considered useful ;)

2007-07-14 Thread Patric de Waha
Hi, Something I'd like to share. I switched to postgres about 4 months ago. The perfomance after a while got worse. I posted a message here, where the result was that my IO was the problem. I run vacuum every night. I never used vacuum full because it is not explicitly

Re: [PERFORM] Vacuum full considered useful ;)

2007-07-14 Thread Tom Lane
Patric de Waha [EMAIL PROTECTED] writes: Yesterday I switched from 8.1 to 8.2. So I needed to dump the dbase and reimport it. The dbase after 4 months of running without vacuum full reached 60 gigabyte of diskspace. Now after a fresh import it only has 5 gigabyte! No

Re: [PERFORM] Vacuum full considered useful ;)

2007-07-14 Thread Vivek Khera
On Jul 14, 2007, at 11:50 AM, Patric de Waha wrote: Yesterday I switched from 8.1 to 8.2. So I needed to dump the dbase and reimport it. The dbase after 4 months of running without vacuum full reached 60 gigabyte of diskspace. Now after a fresh import it only has 5 gigabyte!