Re: multi-column index - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: multi-column index
Date
Msg-id rjgi31hst0r9ok89215vv1ng8boo8ej10u@email.aon.at
Whole thread Raw
In response to Re: multi-column index  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: multi-column index  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: multi-column index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Wed, 16 Mar 2005 22:19:13 -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>calculate the correlation explicitly for each index

May be it's time to revisit an old proposal that has failed to catch
anybody's attention during the 7.4 beta period:
http://archives.postgresql.org/pgsql-hackers/2003-08/msg00937.php

I'm not sure I'd store index correlation in a separate table today.
You've invented something better for functional index statistics, AFAIR.

Servus
 Manfred

pgsql-performance by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: cpu_tuple_cost
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: multi-column index