Postgres Pro
Downloads
Home   >   mailing lists

Re: PG8.2.1 choosing slow seqscan over idx scan - Mailing list pgsql-performance

From Jeremy Haile
Subject Re: PG8.2.1 choosing slow seqscan over idx scan
Date
Msg-id 1169060107.24972.1169765759@webmail.messagingengine.com
Whole thread Raw
In response to Re: PG8.2.1 choosing slow seqscan over idx scan  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-performance
Tree view 
> Also, look at the thread going by about index bloat by 4x.  You'll
> likely want to reindex after a vacuum full since vacuum full doesn't
> reclaim space in indexes and in fact often bloats indexes.

Thanks for the pointer.  That thread might indeed apply to my situation.
 I'm going to reindex the the table tonight.

Jeremy Haile

pgsql-performance by date:

Previous
From: "Jeremy Haile"
Date:
Subject: Re: PG8.2.1 choosing slow seqscan over idx scan
Next
From: Tomas Vondra
Date:
Subject: Re: PG8.2.1 choosing slow seqscan over idx scan