Re: Stats for multi-column indexes

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Stats for multi-column indexes
Date: 2007-03-20 02:14:29
Message-ID: 45FF4385.5010800@paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-03-20 02:14:32 Re: Buildfarm feature request: some way to track/classify failures
Previous Message Jeff Davis 2007-03-20 01:55:56 Re: Stats for multi-column indexes