shared_buffers = 16384
sort_mem = 8192
random_page_cost = 2
effective_cache_size = 3932160
On Fri, 2004-10-22 at 13:32, Tom Lane wrote:
> Cott Lang <[EMAIL PROTECTED]> writes:
> > Oops, sorry - guess I left that out - 7.4.5. :)
>
> Hmm ... I can't duplicate any misbehavior here. Are you using
> nondefault values for any planner parameters? (particularly sort_mem,
> random_page_cost, effective_cache_size)
>
> regards, tom lane
---------------------------(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
