Re: Vacuum (table performance)

From: "Claudio Lapidus" <clapidus(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Vacuum (table performance)
Date: 2003-06-27 12:36:41
Message-ID: BAY7-F104J8uT6Ssuot000329fa@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wries:
> >> Does a REINDEX of the table fix it?
>

Yes, positively it does. After reindexing all five indices of the table,
vacuum times have dropped from minutes to seconds. Looking at pg_class, it
is apparent that there was a cut in the number of tuples of about 30% for
all indices, but the number of pages dropped by about 90%!

Other people mentioned that this probably would get fixed in a forthcoming
release. Is there anything we can do in the meantime?

thanks
cl.

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2003-06-27 12:37:11 Re: [GENERAL] capturing and storing query statement with
Previous Message Hubert Lubaczewski 2003-06-27 11:36:45 Re: column to row