pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Analyze on Foreign Data Wrappers - clarification 2+ messages / 2 participants [nested] [flat]
* Analyze on Foreign Data Wrappers - clarification @ 2021-10-11 13:49 PG Doc comments form <noreply@postgresql.org> 2021-10-11 21:35 ` Re: Analyze on Foreign Data Wrappers - clarification David G. Johnston <david.g.johnston@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: PG Doc comments form @ 2021-10-11 13:49 UTC (permalink / raw) To: pgsql-docs@lists.postgresql.org; +Cc: box1805@gmail.com The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-analyze.html Description: Foreign tables are analyzed only when explicitly selected. Nothing wrong just maybe my newness to PG. I don't understand what "selected" means here: 1. When I select the table in a query 2. When I run the analyze command with the FDW table as a parameter 3. Or something else Also, I am not clear if analyze is run on FDW tables when Automvacuum runs; does it run analyze on FDW tables by default. Thanks, Leon ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Analyze on Foreign Data Wrappers - clarification 2021-10-11 13:49 Analyze on Foreign Data Wrappers - clarification PG Doc comments form <noreply@postgresql.org> @ 2021-10-11 21:35 ` David G. Johnston <david.g.johnston@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: David G. Johnston @ 2021-10-11 21:35 UTC (permalink / raw) To: box1805@gmail.com <box1805@gmail.com>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org> On Monday, October 11, 2021, PG Doc comments form <noreply@postgresql.org> wrote: > > Foreign tables are analyzed only when explicitly selected. > > 2. When I run the analyze command with the FDW table as a parameter > > That > Also, I am not clear if analyze is run on FDW tables when Automvacuum runs; > does it run analyze on FDW tables by default. > Based on the prior item I would expect no. It would usually have insufficient data to do otherwise. I didn’t look hard but aside from this comment about analyze working on foreign tables, if asked, I find no relevant “why” discussion regarding the interaction of analyze and foreign tables in the documentation. Frankly, I’m unsure why it even needs to work at all. David J. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-10-11 21:35 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2021-10-11 13:49 Analyze on Foreign Data Wrappers - clarification PG Doc comments form <noreply@postgresql.org> 2021-10-11 21:35 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox