postgres_fdw - use TABLESAMPLE when analyzing foreign tables

Edit

Title

Topic

Performance

Created

2022-02-11 17:03:42

Last modified

2022-12-30 23:06:03 (1 year, 3 months ago)

Latest email

2023-01-07 15:20:10 (1 year, 3 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

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