does vacuum rebuild index?

From: mikeo <mikeo(at)spectrumtelecorp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: does vacuum rebuild index?
Date: 2000-06-12 21:02:37
Message-ID: 3.0.1.32.20000612170237.009517e0@pop.spectrumtelecorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
we have a 34 million row table. after many inserts, updates, deletes
the performance degraded so we vacuumed the table. the output indicated
that the index was also vacuumed but the size didn't change. it was still
80m so we dropped and recreated it reducing it to 20m. no big deal but
is it common for a vacuum to "miss" the index, so to speak? i saw that
someone else asked a similar question on 6/4 in the general archives but
i found no reply to it. is this a common occurrence or am i doing something
wrong or maybe should be doing something different? this is a 7 column
index on an 11 column table.

xxxxxxx1 | varchar(15) |
xxxxxxx2 | bigint |
xxxxxxx3 | varchar(15) |
xxxxxxx4 | varchar(15) |
xxxxxxx5 | bigint |
xxxxxxx6 | float8 |
xxxxxxx7 | float8 |
xxxxxxx8 | float8 |
xxxxxxx9 | date |
xxxxxxx10 | integer |
xxxxxxx11 | bigint |

the index is on columns 1-5,10,11

thanks,
mikeo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-06-12 21:20:12 Re: does vacuum rebuild index?
Previous Message Trurl McByte 2000-06-12 20:59:30 Hmm... Yet another bug: