pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Manfred Koizar <mkoi-pg@aon.at>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: David Brown <time@bigpond.net.au>
Cc: Josh Berkus <pgsql-performance@postgresql.org>
Subject: Re: multi-column index
Date: Thu, 17 Mar 2005 16:55:15 +0800
Message-ID: <423945F3.8030800@familyhealth.com.au> (raw)
In-Reply-To: <rjgi31hst0r9ok89215vv1ng8boo8ej10u@email.aon.at>
References: <42385A1B.9090305@ibcp.fr>
	<200503161009.24713.josh@agliodbs.com>
	<4238CE87.1040904@bigpond.net.au>
	<19588.1111029553@sss.pgh.pa.us>
	<rjgi31hst0r9ok89215vv1ng8boo8ej10u@email.aon.at>

> 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.

Make it deal with cross-table fk correlations as well :)

Chris



view thread (10+ messages)  latest in thread

Message-ID: <423945F3.8030800@familyhealth.com.au>
Permalink:  ../423945F3.8030800@familyhealth.com.au/
Also on:    postgresql.org/message-id/423945F3.8030800@familyhealth.com.au

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: chriskl@familyhealth.com.au, mkoi-pg@aon.at, tgl@sss.pgh.pa.us, time@bigpond.net.au
  Subject: Re: multi-column index
  In-Reply-To: <423945F3.8030800@familyhealth.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox