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
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
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!