From: Robert Treat <xzilla@users.sourceforge.net>
To: Josh Berkus <josh@agliodbs.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org, Neil Conway <neilc@samurai.com>
Subject: Re: raising the default default_statistics_target
Date: 09 Mar 2004 09:33:48 -0500
Message-ID: <1078842828.22416.335.camel@camel> (raw)
In-Reply-To: <200403081141.06549.josh@agliodbs.com>
References: <auto-000004581775@davinci.ethosmedia.com>
<200403081107.12379.josh@agliodbs.com>
<14956.1078773588@sss.pgh.pa.us>
<200403081141.06549.josh@agliodbs.com>
I think the thread you're thinking of is on or about this post:
http://archives.postgresql.org/pgsql-patches/2003-12/msg00039.php
Manfred Koizar produced a patch that modified index correlation by
sorting equal key values based on item pointers. The patch went as far
as getting accepted into the patch queue, but Tom raised some doubts
about it and it was subsequently removed.
Robert Treat
On Mon, 2004-03-08 at 14:41, Josh Berkus wrote:
> Tom,
>
> > Are you sure you're not thinking of stats for functional indexes?
>
> Positive. I even remember seeing that the patch was accepted.
>
> The patch specifically had to do with a multi-column correlation algorithm for
> improving the selectivity of multi-column indexes.
>
> Problem is, with 1400 posts per month August to October, I can't find it, and
> the keywords that I think are obvious don't turn anything up.
>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
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-hackers@postgresql.org
Cc: xzilla@users.sourceforge.net, josh@agliodbs.com, tgl@sss.pgh.pa.us, neilc@samurai.com
Subject: Re: raising the default default_statistics_target
In-Reply-To: <1078842828.22416.335.camel@camel>
* 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