Re: Why so slow?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Bealach-na Bo <bealach_na_bo(at)hotmail(dot)com>
Cc: jnasby(at)pervasive(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Why so slow?
Date: 2006-04-28 19:00:05
Message-ID: 20060428190005.GA15689@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Apr 28, 2006 at 17:37:30 +0000,
Bealach-na Bo <bealach_na_bo(at)hotmail(dot)com> wrote:
> >The above shows that the indexes contained 10M rows and 160M of dead
> >space each. That means you weren't vacuuming nearly enough.
>
> How is it that a row in the table can grow to a size far exceeding the sum
> of the maximum sized of the fields it consists of?

Because unless you run vacuum, the old deleted rows are not reused. Those
rows cannot be deleted immediately, because the rows may be visible to
other transactions. Periodic vacuums are used to find deleted rows which
are no longer visible to any transactions.

You probably want to read the following:
http://developer.postgresql.org/docs/postgres/routine-vacuuming.html

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Stewart 2006-04-28 20:29:58 Performance Issues on Opteron Dual Core
Previous Message Greg Stumph 2006-04-28 18:36:21 Re: Worsening performance with 7.4 on flash-based system