Re: raising the default default_statistics_target

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, Neil Conway <neilc(at)samurai(dot)com>
Subject: Re: raising the default default_statistics_target
Date: 2004-03-09 14:33:48
Message-ID: 1078842828.22416.335.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)postgresql(dot)org)

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-03-09 15:02:14 Re: [PATCHES] log_line_info
Previous Message Tatsuo Ishii 2004-03-09 12:53:15 Re: [PATCHES] NO WAIT ...