Re: Weird performance difference

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Israel Brewster <israel(at)ravnalaska(dot)net>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Weird performance difference
Date: 2017-10-22 09:45:34
Message-ID: CAB7nPqRE_wy-GWwtiFE-zWccSEFyNRjhEZCDB39FkSpoeKOhwQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Oct 21, 2017 at 9:38 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Also try explicitly ANALYZE'ing the foreign tables. I do not
> believe auto-analyze will touch foreign tables ...

Autovacuum and autoanalyze only process relations and matviews,
discarding the rest when scanning pg_class. See do_autovacuum().
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rakeshkumar464 2017-10-22 12:32:56 How to get login user name and host name in pgaudit
Previous Message Günce Kaya 2017-10-22 09:03:15 Re: A question on pg_stat_subscription view