postgres_fdw connection caching enable/disable or timeout feature

Edit

Title

Topic

Server Features

Created

2020-07-17 11:50:07

Last modified

2020-12-01 11:10:36 (1 month, 3 weeks ago)

Latest email

2021-01-21 18:29:02 (9 hours, 55 minutes ago)

Status

2021-01: Needs review

2020-11: Moved to next CF

2020-09: Moved to next CF

Target version

Authors

Bharath Rupireddy (bharathrupireddy)

Reviewers

Alexey Kondratov (ololobus)Become reviewer

Committer

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-01-21 18:29:02 by Fujii Masao <masao.fujii at oss.nttdata.com>
Latest 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>
    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
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