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

From Manfred Koizar
Subject Re: multi-column index
Date
Msg-id i2pi31d7ea6qg67f5av9i7h0gscqk7tgjm@email.aon.at
Whole thread Raw
In response to Re: multi-column index  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-performance
On Thu, 17 Mar 2005 16:55:15 +0800, Christopher Kings-Lynne
<chriskl@familyhealth.com.au> wrote:
>Make it deal with cross-table fk correlations as well :)

That's a different story.  I guess it boils down to cross-column
statistics for a single table.  Part of this is the correlation between
values in two or more columns, which is not the same as the correlation
between column (or index tuple) values and tuple positions.

And yes, I did notice the smiley ;-)

Servus
 Manfred

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: multi-column index
Next
From: Gaetano Mendola
Date:
Subject: 2 rows expected on a primary key