Re: Hints (Was: Index Tuning Features) - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Hints (Was: Index Tuning Features)
Date
Msg-id 1060.24.211.165.134.1160704910.squirrel@www.dunslane.net
Whole thread Raw
In response to Re: Hints (Was: Index Tuning Features)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

> We have also talked about solving the multi-column statistics problem
> (which, at its core, is "which combinations of columns are worth
> accumulating stats for?" --- you can't possibly store stats for every
> combination!) by having what would amount to hints from the DBA saying
> "keep stats for these combinations".
>

This strikes me intuitively as the most likely candidate so far for
improvement. I'm much more interested in schemes that will improve the
stats system, rather than providing a way around it.

cheers

andrew



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Hints (Was: Index Tuning Features)
Next
From: Christopher Browne
Date:
Subject: Re: [PERFORM] Hints proposal