Skip site navigation (1) Skip section navigation (2)

Re: Increasing statistics results in worse estimates

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shelby Cain <alyandon(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Increasing statistics results in worse estimates
Date: 2005-04-29 14:04:17
Message-ID: 5540.1114783457@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Shelby Cain <alyandon(at)yahoo(dot)com> writes:
> Increasing the statistics target on the city column
> and re-analyzing the table seems to make the
> correlation estimate better (shows about 0.5) but the
> row count estimates are thrown off by 2 orders of
> magnitude in some cases.

What did you increase it to, exactly?  Could we see the contents of
pg_stats for these two columns at both target settings?

			regards, tom lane

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2005-04-29 14:36:05
Subject: Re: [GENERAL] Returning a RECORD, not SETOF RECORD
Previous:From: Scott MarloweDate: 2005-04-29 13:45:05
Subject: Re: Postgresql and VBA vs Python

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group