Re: cross column correlation revisted - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: cross column correlation revisted
Date
Msg-id 4C3DCAF3.4000401@dunslane.net
Whole thread Raw
In response to Re: cross column correlation revisted  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:
> If the combination of columns is actually interesting, there might well
> be an index in place, or the DBA might be willing to create it.  

I'm having a hard time imagining an interesting case where that wouldn't 
be so.

> For
> that matter, have you considered the idea of examining the index
> contents to derive the statistics?  Might work better than trying to get
> numbers via ANALYZE.
>
>   

Sounds like a good idea.

cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: cross column correlation revisted
Next
From: Robert Haas
Date:
Subject: Re: five-key syscaches