| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | rob stone <floriparob(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: pg_prepared_statements |
| Date: | 2020-01-21 03:22:32 |
| Message-ID: | CAKFQuwYMaUPgVCS18FrrLdvjxHNkBcpM=QqbLvOiC1Yp_g6Avg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jan 20, 2020 at 8:00 PM rob stone <floriparob(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ramesh Penuballi | 2020-01-21 06:20:10 | Re: postgresql commands(psql,createdb,dropdb) are not working from shell script |
| Previous Message | David G. Johnston | 2020-01-21 03:18:02 | Re: pg_prepared_statements |