| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Casey Duncan <casey(at)pandora(dot)com>, Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
| Subject: | Re: Hints (Was: Index Tuning Features) |
| Date: | 2006-10-13 21:32:08 |
| Message-ID: | 200610131432.09973.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2006-10-13 21:41:09 | Re: more anti-postgresql FUD |
| Previous Message | Thomas Kellerer | 2006-10-13 21:11:13 | Re: more anti-postgresql FUD |