Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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:

In response to


pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group