On 2022-Dec-30, Tomas Vondra wrote: > Sample postgres_fdw tables remotely during ANALYZE > > When collecting ANALYZE sample on foreign tables, postgres_fdw fetched > all rows and performed the sampling locally. For large tables this means > transferring and immediately discarding large amounts of data. > > This commit allows the sampling to be performed on the remote server, > transferring only the much smaller sample. The sampling is performed > using the built-in TABLESAMPLE methods (system, bernoulli) or random() > function, depending on the remote server version. > > Remote sampling can be enabled by analyze_sampling on the foreign server > and/or foreign table, with supported values 'off', 'auto', 'system', > 'bernoulli' and 'random'. The default value is 'auto' which uses either > 'bernoulli' (TABLESAMPLE method) or 'random' (for remote servers without > TABLESAMPLE support).
You left out the Discussion line, so here's the link: https://postgr.es/m/[email protected] -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ "Nunca se desea ardientemente lo que solo se desea por razón" (F. Alexandre)
