Re: suggestions on improving a query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rguha(at)indiana(dot)edu
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: suggestions on improving a query
Date: 2007-02-14 02:44:51
Message-ID: 6003.1171421091@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rajarshi Guha <rguha(at)indiana(dot)edu> writes:
> However the clause:
> dock.target = '1YC1' and
> dock.dockid = dockscore_plp.id
> reduces the number of rows from 4.6M to 96K.

The planner seems to be estimating about ten times that many. Perhaps
increasing the statistics target for dock.target would help?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2007-02-14 02:46:05 Re: [GENERAL] ISO week dates
Previous Message Bruce Momjian 2007-02-14 02:43:43 Re: [GENERAL] ISO week dates