Re: Stats for multi-column indexes - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: Stats for multi-column indexes
Date
Msg-id 45FF4385.5010800@paradise.net.nz
Whole thread Raw
In response to Re: Stats for multi-column indexes  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Stats for multi-column indexes  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-hackers
Jeff Davis wrote:
>
> I know we can't keep stats on every combination of columns. My initial
> idea would be to only keep stats about a multi-column index (and
> probably optional for those, too).
> 

Maybe you would want to keep single column indexes too, so that (more) 
accurate estimates for bitmap-and type plans are possible.

Cheers

Mark


pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Stats for multi-column indexes
Next
From: Andrew Dunstan
Date:
Subject: Re: Buildfarm feature request: some way to track/classify failures