Re: How to inject knowledge into a Postgres database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: han(dot)holl(at)informationslogik(dot)nl
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to inject knowledge into a Postgres database
Date: 2005-10-07 14:08:24
Message-ID: 3549.1128694104@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

han(dot)holl(at)informationslogik(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-10-07 14:17:21 Re: [HACKERS] Shell script to extract a table from a plain text dump
Previous Message Andrus 2005-10-07 14:07:03 Re: PostgreSQL 8.1 vs. MySQL 5.0?