Subject: Re: raising the default default_statistics_target
From: Robert Treat <xzilla@users.sourceforge.net>
To: Josh Berkus <josh@agliodbs.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org,
	Neil Conway <neilc@samurai.com>
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>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Date: 09 Mar 2004 09:33:48 -0500
Message-Id: <1078842828.22416.335.camel@camel>
Mime-Version: 1.0

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