Re: nested query vs left join: query planner very confused - Mailing list pgsql-general

On Wed, 27 Nov 2013 11:06:51 -0500, bricklen <bricklen@gmail.com> wrote:
> Has the client ANALYZEd recently? What happens if the client issues
> the following commands before executing the query?
> VACUUM ANALYZE lp.sigs;
> VACUUM ANALYZE lp.mags;
>
> If that doesn't change the plan, could you post the values for
> effective_cache_size, shared_buffers, random_page_cost,
> cpu_tuple_cost, work_mem and how much RAM is in the client machine?

Yes, I did have them do a vacuum analyze with no result. Here's their
reply on configuration:

           It is 24 Gig.

           effective_cache_size - 12000MB
           shared_buffers - 1024MB
           random_page_cost - is commented out
           cpu_tuple_cost -  commented out
           work_mem - commented out

I assume you guys already know the default values for those last 3 on a
9.0.x server...