On Fri, 2004-10-22 at 14:19, Tom Lane wrote:
> Cott Lang <[EMAIL PROTECTED]> writes:
> > sort_mem = 8192
> > random_page_cost = 2
> > effective_cache_size = 3932160
>
> effective_cache_size 30Gb ? Seems a tad high ;-)
It's a 32GB machine with nothing else running on it except PG, buffers
hover around 31GB :)
> However, I set up a dummy test case on 7.4.5 and don't see any overflow.
> Can you try this exact test case and see if you get a NAN?
I don't. After a bounce, I also can't repeat my original case; it now
returns 16.60.
Fiddling with the above values, only setting sort_mem absurdly large
easily causes NAN.
My guess is there was a wonky setting for sort_mem that disappeared
after I bounced.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
