postgres_fdw - use TABLESAMPLE when analyzing foreign tables

Edit
Comment/Review
Change Status
ID 3535
Title postgres_fdw - use TABLESAMPLE when analyzing foreign tables
Topic Performance
Created 2022-02-11 17:03:42
Last modified 2022-12-30 23:06:03 (1 year, 11 months ago)
Latest email 2023-01-07 15:20:10 (1 year, 10 months ago)
Status
2023-01: Committed
2022-11: Moved to next CF
2022-09: Moved to next CF
2022-07: Moved to next CF
2022-03: Moved to next CF
Target version
Authors Tomas Vondra (fuzzycz)
Reviewers Tom Lane (tgl), James Finnerty (jimfinnerty)Become reviewer
Committer Tomas Vondra (fuzzycz)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run: 
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3535
git checkout commitfest/cf/3535
Emails
postgres_fdw: using TABLESAMPLE to collect remote sample
First at 2022-02-11 17:02:37 by Tomas Vondra <tomas.vondra at enterprisedb.com>
Latest at 2023-01-07 15:20:10 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (0001-Check-relkind-before-using-TABLESAMPLE-in-postgres_f.patch) at 2023-01-06 14:40:36 from Tomas Vondra <tomas.vondra at enterprisedb.com>
    Attachment (0001-Check-relkind-before-using-TABLESAMPLE-in-postgres_f.patch) at 2023-01-06 14:40:36 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0002-WIP-check-relkind-in-FDW-analyze.patch) at 2023-01-05 20:43:42 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (run-remote.sh) at 2022-10-07 23:43:56 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (0001-postgres_fdw-sample-data-tomas.patch) at 2022-07-18 18:45:10 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0001-postgres_fdw-sample-data-on-remote-node-for-20220718.patch) at 2022-07-18 11:36:23 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-postgres_fdw-sample-data-on-remote-node-for-20220716.patch) at 2022-07-16 21:57:44 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0001-postgres_fdw-sample-data-on-remote-node-for-20220222.patch) at 2022-02-22 23:51:24 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-postgres_fdw-track-server-version-for-conne-20220218.patch) at 2022-02-18 13:28:48 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (postgres-fdw-analyze-sample-20220211.patch) at 2022-02-11 17:02:37 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
History
When Who What
2022-12-30 23:06:03 Tomas Vondra (fuzzycz) Closed in commitfest 2023-01 with status: Committed
2022-12-30 23:06:03 Tomas Vondra (fuzzycz) Changed committer to fuzzycz
2022-12-15 16:34:35 James Finnerty (jimfinnerty) Posted comment with messageid <167112207543.1120.12195641719862911275.pgcf@coridan.postgresql.org>
2022-12-15 15:10:37 James Finnerty (jimfinnerty) Added jimfinnerty as reviewer
2022-12-12 13:16:05 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-10-12 07:05:36 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-08-01 22:38:32 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-07-18 13:37:14 Tomas Vondra (fuzzycz) New status: Needs review
2022-07-16 21:49:31 Tom Lane (tgl) Added tgl as reviewer
2022-04-08 12:58:51 Greg Stark (stark) Closed in commitfest 2022-03 with status: Moved to next CF
2022-03-22 01:18:24 Andres Freund (andresfreund) New status: Waiting on Author
2022-02-15 02:42:43 Justin Pryzby (justinpryzby) Changed authors to Tomas Vondra (fuzzycz)
2022-02-11 17:03:42 Tomas Vondra (fuzzycz) Attached mail thread 151e835f-55d6-ddbc-b5b4-07ee606aba44@enterprisedb.com
2022-02-11 17:03:42 Tomas Vondra (fuzzycz) Created patch record
Edit
Comment/Review
Change Status