jackc / jackc/pgx

Support / Howto set "plan_cache_mode" planner option in PG12

Open
#1,101 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Go
Stars
14.3k
Forks
1.1k
Avg merge
6d 9h
Merged PRs (30d)
11

Description

How can I set the new "plan_cache_mode" planner option on connect to a PG12 server, from PGX.

I'm using Connection pools, if that makes a difference.

see: https://postgresqlco.nf/doc/en/param/plan_cache_mode/

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the issue's PostgreSQL 12 plan_cache_mode reference and the pgx connection-pool context. Determine whether the option can be configured when connecting to a PG12 server, then document how it should be set for pooled connections. Done means the how-to question is answered clearly for pgx users.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, postgresql
Domain
database
Issue type
Documentation
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.