Re: An unresolved performance problem. - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: An unresolved performance problem.
Date
Msg-id 20030508112020.GB3728@libertyrms.info
Whole thread Raw
In response to Re: An unresolved performance problem.  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: An unresolved performance problem.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Thu, May 08, 2003 at 10:48:52AM -0200, Achilleus Mantzios wrote:

> That is, we have a marginal decrease of the total cost
> for the index scan when random_page_cost = 1.9,
> whereas the "real cost" in the means of total runtime
> ranges from 218 msecs (seq scan) to 19 msecs (index scan).
> (is it sane?)

You're right that the problem is the poor estimate of the cost of
that selection.  I recall you mentioning that you'd expanded the
statistics on the field, but I don't recall to what.  I know that
under some circumstances, you _really_ have to increase the stats to
get a meaningful sample.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-performance by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: An unresolved performance problem.
Next
From: Tom Lane
Date:
Subject: Re: An unresolved performance problem.