Re: [GENERAL] Partial index does not make query faster

2012-01-18 Thread Tom Lane
Ruben Blanco writes: > I'm trying to reduce execution time on a query using a partial index, > but Postgres doesn't make a significant improvement, even when the > partial index is 30 times smaller than the index used currently. That doesn't really matter that much. The part of the index a given

[GENERAL] Partial index does not make query faster

2012-01-18 Thread Ruben Blanco
Hi, folks: I'm trying to reduce execution time on a query using a partial index, but Postgres doesn't make a significant improvement, even when the partial index is 30 times smaller than the index used currently. Query plan returns a slightly higher cost (cost=0.00..327952.12) for the partial inde