> And now, the optimizer started to use a table scan and in consequence gives
What appears to me to be happening is that the planner has incorrect estimates
of the cost of an index lookup. The base estimate is contained in the
cpu_index_tuple_cost = 0.001
From the look of things, your disk/array has much better random seek times
than the standard, or you have enough RAM to cache most of your tables.
Either way, I would experiment with lowering the index_tuple_cost to, say,
0.0003 and see if you get better use of indexes.
If that does work for you, make sure to check some other queries unrelated to
the "customers" table to make sure that the new setting doesn't mess them up
in some way.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Stephan Szabo||Date: 2003-05-13 19:45:27|
|Subject: Re: How are null's stored? |
|Previous:||From: Tom Lane||Date: 2003-05-13 14:46:12|
|Subject: Re: [repost] partial index / funxtional idx or bad sql? |