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

From Josh Berkus
Subject Re: Hints (Was: Index Tuning Features)
Date
Msg-id 200610131432.09973.josh@agliodbs.com
Whole thread Raw
In response to Re: Hints (Was: Index Tuning Features)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom,

> 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".

We could start just by keeping stats for multiple columns which are indexed 
together.  That doesnt' cover everything (thanks to bitmapping) but would 
cover many cases.

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: ./configure argument checking
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] index advisor