Wes <[EMAIL PROTECTED]> writes:
> On 4/4/05 8:50 AM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
>> That doesn't follow from what you said. Did you check that the physical
>> sizes of the indexes were comparable before and after the reindex?
> No, how do I do that (or where is it documented how to do it)?
The best way is probably to capture the output of VACUUM VERBOSE (not FULL)
for the table before and after REINDEX.
> How is it not consistent?
I didn't say it wasn't consistent, just that it doesn't prove the
point. The speedup you saw could have been from elimination of index
bloat more than from bringing the index into physically sorted order.
An estimate of the overall database size doesn't really tell us how
much this particular table's indexes changed in size.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
