postgres_fdw - use TABLESAMPLE when analyzing foreign tables

Edit

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, 10 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