Re: Maximum statistics target - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Maximum statistics target
Date
Msg-id 20080307184157.GA23644@svana.org
Whole thread Raw
In response to Maximum statistics target  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Maximum statistics target  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Mar 07, 2008 at 07:25:25PM +0100, Peter Eisentraut wrote:
> What's the problem with setting it to ten million if I have ten million values
> in the table and I am prepared to spend the resources to maintain those
> statistics?

That it'll probably take 10 million seconds to calculate the plans
using it? I think Tom pointed there are a few places that are O(n^2)
the number entries...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

pgsql-hackers by date:

Previous
From: Andrew Chernow
Date:
Subject: Re: Commitfest status
Next
From: Aidan Van Dyk
Date:
Subject: Re: Commitfest status