Why do things slow down without a VACUUM?

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: pgsql-general(at)postgresql(dot)org
Subject: Why do things slow down without a VACUUM?
Date: 2001-04-30 01:14:04
Message-ID: 3.0.5.32.20010430091404.010dd7d0@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Why do things slow down after a lot of updates without a VACUUM? This
slow-down doesn't seem to happen as much with a lot of inserts.

Don't the indexes know which is the valid updated row? Or does Postgresql
still have to search for it amongst deleted/invalid rows?

I can understand why the database would bloat up and/or slow down slightly
without a vacuum. But why such a significant slowdown? So much so that
people have to vacuum every two hours.

Cheerio,
Link.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message GH 2001-04-30 02:17:43 Re: Why do things slow down without a VACUUM?
Previous Message Bruce Momjian 2001-04-29 23:28:57 Re: Re: On the _need_ to vacuum...