postgres_fdw connection caching enable/disable or timeout feature

Edit

Title

Topic

Server Features

Created

2020-07-17 11:50:07

Last modified

2021-04-02 10:48:23 (6 months, 4 weeks ago)

Latest email

2021-04-02 10:47:39 (6 months, 4 weeks ago)

Status

2021-03: Committed

2021-01: Moved to next CF

2020-11: Moved to next CF

2020-09: Moved to next CF

Target version

Authors

Bharath Rupireddy (bharathrupireddy)

Reviewers

Fujii Masao (masaofujii), Alexey Kondratov (ololobus)Become reviewer

Committer

Fujii Masao (masaofujii)

Links

Emails

[PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit: First at 2020-06-22 05:55:54 by Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
Latest at 2021-04-02 10:47:39 by Fujii Masao <masao.fujii at oss.nttdata.com>
Latest attachment (v23-0003-postgres_fdw-server-level-option-keep_connection.patch) at 2021-04-01 16:13:42 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
    Attachment (v23-0003-postgres_fdw-server-level-option-keep_connection.patch) at 2021-04-01 16:13:42 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v22-0003-postgres_fdw-server-level-option-keep_connection.patch) at 2021-04-01 15:26:06 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v21-0002-postgres_fdw-add-keep_connections-GUC-to-not-cac.patch) at 2021-02-22 05:55:31 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v20-0002-postgres_fdw-add-keep_connections-GUC-to-not-cac.patch) at 2021-02-04 04:06:42 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (postgres_fdw.patch) at 2021-01-29 18:44:30 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v1-0001-Don-t-return-valid-state-in-postgres_fdw_get_conn.patch) at 2021-01-29 10:45:43 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-connection-closure-issue-in-pgfdw_inval_callb.patch) at 2021-01-29 05:25:35 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v19-0002-postgres_fdw-add-keep_connections-GUC-to-not-cac.patch) at 2021-01-27 01:06:41 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Stabilize-test-case-for-postgres_fdw_disconnect_a.patch) at 2021-01-26 08:07:03 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v18-0001-postgres_fdw-Add-functions-to-discard-cached-connect.patch) at 2021-01-25 19:08:27 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v17-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-25 15:12:39 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v16-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-21 16:17:40 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v15-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-21 03:00:22 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v14-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-20 10:17:01 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v13-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-19 03:09:47 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (0001-doc-Add-note-about-the-server-name-of-postgres_fdw_g.patch) at 2021-01-18 15:57:55 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v12-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-18 14:14:30 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (postgres_fdw_get_connections_v2.patch) at 2021-01-18 04:46:40 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (postgres_fdw_get_connections_v1.patch) at 2021-01-18 04:08:07 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v11-0001-postgres_fdw-functions-to-show-and-discard-cache.patch) at 2021-01-18 03:33:56 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v10-0001-postgres_fdw-function-to-discard-cached-connecti.patch) at 2021-01-17 07:39:27 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (serverid_v1.patch) at 2021-01-14 10:22:19 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v9-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2021-01-09 01:12:26 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v8-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2021-01-05 07:56:14 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v7-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2021-01-02 05:49:17 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v6-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2021-01-02 05:23:40 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v5-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2021-01-01 10:03:33 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v4-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2020-12-30 11:50:23 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v4-0001-postgres_fdw-function-to-discard-cached-connectio.patch) at 2020-12-30 06:10:29 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v3-0004-postgres_fdw-connection-cache-discard-tests-and-documentation.patch) at 2020-12-04 11:15:29 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v2-0001-postgres_fdw-connection-cache-disconnect-function.patch) at 2020-11-27 02:12:50 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-postgres_fdw-function-to-discard-cached-connections.patch) at 2020-11-23 06:48:42 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (pgfdw_keep_connections.diff) at 2020-11-17 19:37:28 from Alexey Kondratov <a.kondratov at postgrespro.ru> (Patch: Yes)
    Attachment (v1-0001-Retry-cached-remote-connections-in-case-if-remote.patch) at 2020-07-02 10:59:33 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (testcase) at 2020-06-22 05:55:54 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: No)

History

When	Who	What
2021-04-02 10:48:23	Fujii Masao (masaofujii)	Closed in commitfest 2021-03 with status: Committed
2021-04-01 17:22:44	Fujii Masao (masaofujii)	New status: Ready for Committer
2021-04-01 14:54:03	Fujii Masao (masaofujii)	Added masaofujii as reviewer
2021-04-01 14:54:00	Fujii Masao (masaofujii)	Added masaofujii as committer
2021-02-01 12:45:49	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-01 11:10:36	Anastasia Lubennikova (lubennikovaav)	Closed in commitfest 2020-11 with status: Moved to next CF
2020-11-23 06:50:07	Bharath Rupireddy (bharathrupireddy)	New status: Needs review
2020-11-19 13:48:08	Alexey Kondratov (ololobus)	Added ololobus as reviewer
2020-11-06 15:56:25	Anastasia Lubennikova (lubennikovaav)	Posted comment with messageid <160467818521.7362.11186359886835925531.pgcf@coridan.postgresql.org>
2020-11-06 15:56:25	Anastasia Lubennikova (lubennikovaav)	New status: Waiting on Author
2020-09-29 06:20:23	Bharath Rupireddy (bharathrupireddy)	Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-29 06:20:13	Bharath Rupireddy (bharathrupireddy)	New status: Needs review
2020-09-29 05:45:18	Michael Paquier (michael-kun)	New status: Waiting on Author
2020-08-10 12:34:20	Bharath Rupireddy (bharathrupireddy)	New status: Needs review
2020-07-17 11:50:43	Bharath Rupireddy (bharathrupireddy)	New status: Waiting on Author
2020-07-17 11:50:20	Bharath Rupireddy (bharathrupireddy)	Changed authors to Bharath Rupireddy (bharathrupireddy)
2020-07-17 11:50:07	Bharath Rupireddy (bharathrupireddy)	Attached mail thread CALj2ACVvrp5=AVp2PupEm+nAC8S4buqR3fJMmaCoc7ftT0aD2A@mail.gmail.com
2020-07-17 11:50:07	Bharath Rupireddy (bharathrupireddy)	Created patch record

Edit