Re: Statistics Import and Export

2024-11-18 Thread Wetmore, Matthew (CTR)
Sorry to chime in with a dumb question: How would/could this effect tables that have the vacuum and analyze scale_factors different from the rest of db via the ALTE RTABLE statement? (I do this a lot) ALTER TABLE your_schema.your_table SET (autovacuum_enabled,autovacuum_analyze_scale_factor,au

Re: Non-trivial condition is only propagated to one side of JOIN

2024-08-26 Thread Wetmore, Matthew (CTR)
You must use a where clause on the FDW table or you get a full load/SEQ scan of that table, per documentation. Select * is not recommended for FDW tables. From: Tobias Hoffmann Date: Sunday, August 25, 2024 at 8:10 AM To: "pgsql-hack...@postgresql.org" Subject: Non-trivial condition is only pr