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