Re: [PERFORM] Bad n_distinct estimation; hacks suggested? - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: [PERFORM] Bad n_distinct estimation; hacks suggested?
Date
Msg-id 1114557011.77587.107.camel@home
Whole thread Raw
In response to Re: [PERFORM] Bad n_distinct estimation; hacks suggested?  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
On Tue, 2005-04-26 at 19:03 -0400, Greg Stark wrote:
> This one looks *really* good. 
> 
>  http://www.aladdin.cs.cmu.edu/papers/pdfs/y2001/dist_sampl.pdf
> 
> It does require a single full table scan 

Ack.. Not by default please.

I have a few large append-only tables (vacuum isn't necessary) which do
need stats rebuilt periodically.

Lets just say that we've been working hard to upgrade to 8.0 primarily
because pg_dump was taking over 18 hours to make a backup.

-- 
Rod Taylor <rbt@sitesell.com>



pgsql-hackers by date:

Previous
From: "Dave Held"
Date:
Subject: Re: [PERFORM] Bad n_distinct estimation; hacks suggested?
Next
From: Brent Verner
Date:
Subject: Re: [proposal] protocol extension to support loadable stream filters