Horton

Re: multi-column index

Manfred Koizar <mkoi-pg@aon.at>

View thread View on postgr.es
From: Manfred Koizar <mkoi-pg@aon.at>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, David Brown <time@bigpond.net.au>, Josh Berkus <pgsql-performance@postgresql.org>
Date: 2005-03-17T11:18:28Z
Lists: 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