On Tue, 2007-01-09 at 23:12, Tom Lane wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
> > On Tue, 2007-01-09 at 17:17, Ben wrote:
> > If I create an index on a table that needs to be vacuumed in 7.3, will the
> > dead rows get indexed as well?
>
> > Yes. I think. I'm pretty sure that's still
Scott Marlowe <[EMAIL PROTECTED]> writes:
> On Tue, 2007-01-09 at 17:17, Ben wrote:
> If I create an index on a table that needs to be vacuumed in 7.3, will the
> dead rows get indexed as well?
> Yes. I think. I'm pretty sure that's still true in 8.2. as well. The
> way indexes work is that th
On Tue, 2007-01-09 at 17:17, Ben wrote:
> And a related question: should a vacuum also clean out indexes on 7.3?
Should, might not. There definitely was a problem in 7.2 with indexes
on ever increasing values where the indexes would grow on one side of
the btree only. In 7.2 I had a table of abo
And a related question: should a vacuum also clean out indexes on 7.3?
On Tue, 9 Jan 2007, Ben wrote:
If I create an index on a table that needs to be vacuumed in 7.3, will the
dead rows get indexed as well?
---(end of broadcast)---
TIP 9: In ve
If I create an index on a table that needs to be vacuumed in 7.3, will the
dead rows get indexed as well?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining colum
