Re: Better estimates of index correlation - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Better estimates of index correlation
Date
Msg-id 1300112623-sup-7438@alvh.no-ip.org
Whole thread Raw
In response to Re: Better estimates of index correlation  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Better estimates of index correlation
Re: Better estimates of index correlation
List pgsql-hackers
Excerpts from Robert Haas's message of lun mar 14 11:18:24 -0300 2011:
> On Mon, Mar 14, 2011 at 10:09 AM, Alvaro Herrera
> <alvherre@commandprompt.com> wrote:

> > It sure would be nice to be able to do it only during the last scan.
> 
> Does it really matter?  What Tom was describing sounded embarassingly cheap.

Well, you only do multiple passes for tables that are really large, so
it's precisely there that you want to save the extra overhead of having
to do it multiple times.

As Heikki says, maybe this wouldn't be an issue at all if we can do it
during ANALYZE instead, but I don't know if that works.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Shared invalidation cache messages for temporary tables
Next
From: Robert Haas
Date:
Subject: Re: Shared invalidation cache messages for temporary tables