Re: Better estimates of index correlation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Better estimates of index correlation
Date
Msg-id 8231.1300150304@sss.pgh.pa.us
Whole thread Raw
In response to Re: Better estimates of index correlation  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Better estimates of index correlation
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
>> I'm not convinced you can get a sufficiently good estimate from a small
>> subset of pages.

> Note that if this requires VACUUM rather than ANALYZE, it introduces a
> problem for data warehousing users, who can go years between vacuums of
> their largest tables.

It's likely that the default estimate of zero index correlation will
work just fine for such users ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Better estimates of index correlation
Next
From: Josh Berkus
Date:
Subject: Re: Better estimates of index correlation