Postgres Pro
Downloads
Home   >   mailing lists

Re: Column correlation drifts, index ignored again - Mailing list pgsql-performance

From Tom Lane
Subject Re: Column correlation drifts, index ignored again
Date
Msg-id 18941.1077487618@sss.pgh.pa.us
Whole thread Raw
In response to Column correlation drifts, index ignored again  (John Siracusa <siracusa@mindspring.com>)
Responses Re: Column correlation drifts, index ignored again
List pgsql-performance
Tree view 
John Siracusa <siracusa@mindspring.com> writes:
>   I want to do something that will convince Postgres that using the date
> index is, by far, the best plan when running my queries, even when the
> date column correlation stat drops well below 1.0.

Have you tried experimenting with random_page_cost?  Seems like your
results suggest that you need to lower it.

            regards, tom lane

pgsql-performance by date:

Previous
From: John Siracusa
Date:
Subject: Re: Column correlation drifts, index ignored again
Next
From: John Siracusa
Date:
Subject: Re: Column correlation drifts, index ignored again