Home > mailing lists

Re: pg_prepared_statements - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: pg_prepared_statements
Date	January 21, 2020 06:22:32
Msg-id	CAKFQuwYMaUPgVCS18FrrLdvjxHNkBcpM=QqbLvOiC1Yp_g6Avg@mail.gmail.com Whole thread Raw
In response to	pg_prepared_statements (rob stone <floriparob@gmail.com>)
List	pgsql-general

Tree view

On Mon, Jan 20, 2020 at 8:00 PM rob stone <floriparob@gmail.com> wrote:

max_prepared_transactions = 6 is the value set in postgresql.conf.

This has nothing to do with the feature that the pg_prepared_statements view tracks.

It is for the two-phase commit prepared transactions, not prepared statements.

https://www.postgresql.org/docs/12/runtime-config-resource.html#GUC-MAX-PREPARED-TRANSACTIONS

David J.

pgsql-general by date:

From: "David G. Johnston"
Date: 21 January 2020, 06:18:02
Subject: Re: pg_prepared_statements

From: Ramesh Penuballi
Date: 21 January 2020, 09:20:10
Subject: Re: postgresql commands(psql,createdb,dropdb) are not working fromshell script

Re: pg_prepared_statements - Mailing list pgsql-general

Previous

Next