Re: How to get explain plan to prefer Hash Join

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: atxcanadian <matthew(dot)boyda(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to get explain plan to prefer Hash Join
Date: 2015-03-12 15:53:46
Message-ID: CAMkU=1x4acNJPAUccyiSihQJpK0gULi3JuyEuET5=KBtZ1ZxEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Mar 11, 2015 at 5:35 PM, atxcanadian <matthew(dot)boyda(at)gmail(dot)com>
wrote:

>
> I'm a little perplexed why the autovacuum wasn't keeping up. Any
> recommendations for those settings to push it to do a bit more analyzing of
> the tables??
>

What does pg_stat_user_tables show for that table?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message atxcanadian 2015-03-12 15:59:34 Re: How to get explain plan to prefer Hash Join
Previous Message atxcanadian 2015-03-12 15:45:38 Re: How to get explain plan to prefer Hash Join