Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql 8.3 statistic stadistinct value dead wrong even with default_statistics_target=1000 - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgresql 8.3 statistic stadistinct value dead wrong even with default_statistics_target=1000
Date
Msg-id 13326.1219419455@sss.pgh.pa.us
Whole thread Raw
In response to Postgresql 8.3 statistic stadistinct value dead wrong even with default_statistics_target=1000  (Maxim Boguk <mboguk@masterhost.ru>)
Responses Re: Postgresql 8.3 statistic stadistinct value dead wrong even with default_statistics_target=1000
List pgsql-general
Tree view 
Maxim Boguk <mboguk@masterhost.ru> writes:
> [ ndistinct estimates way off ]

Estimating the number of distinct values in a distribution with a long
tail is just a really hard problem :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: SERIAL datatype
Next
From: Alvaro Herrera
Date:
Subject: Re: problem with foreign keys + data-only backup