Re: How to inject knowledge into a Postgres database - Mailing list pgsql-general

From Tom Lane
Subject Re: How to inject knowledge into a Postgres database
Date
Msg-id 3549.1128694104@sss.pgh.pa.us
Whole thread Raw
In response to How to inject knowledge into a Postgres database  (han.holl@informationslogik.nl)
List pgsql-general
han.holl@informationslogik.nl 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

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: PostgreSQL 8.1 vs. MySQL 5.0?
Next
From: smorrey@gmail.com
Date:
Subject: multiple default values specified for column?