Re: index creation on 7.3 - Mailing list pgsql-general

From Ben
Subject Re: index creation on 7.3
Date
Msg-id Pine.LNX.4.64.0701091516450.8626@localhost.localdomain
Whole thread Raw
In response to index creation on 7.3  (Ben <bench@silentmedia.com>)
Responses Re: index creation on 7.3  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
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 versions below 8.0, the planner will ignore your desire to
>      choose an index scan if your joining column's datatypes do not
>      match
>

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Questions about horizontal partitioning
Next
From: Jonathan Hedstrom
Date:
Subject: Re: ERROR: invalid memory alloc request size, and others