Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes: > What lead to degradation was the bumping off of > effective_cache_size parameter from 1000 to 64K
Check the plan then; AFAIR the only possible effect of changing effective_cache_size is to influence which plan the planner picks. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html