[EMAIL PROTECTED] writes: > Is there a way to tell the planner to always prefer the dateofbirth index ? > Alternatively, to inform it about the wildly uneven distribution of surnames > (this must be even worse in China).
Increase the statistics target for that column, and re-ANALYZE the
table.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
