Re: pg_prepared_statements

2020-01-20 Thread David G. Johnston
On Mon, Jan 20, 2020 at 8:00 PM rob stone 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.

Re: pg_prepared_statements

2020-01-20 Thread David G. Johnston
On Mon, Jan 20, 2020 at 8:00 PM rob stone wrote: > Hello, > > PostgreSQL 11.6 (Debian 11.6-2~sid1) on x86_64-pc-linux-gnu, compiled > by gcc (Debian 9.2.1-21) 9.2.1 20191130, 64-bit > > Is there something awry with the pg_prepared_statements view? > This is the only ro

pg_prepared_statements

2020-01-20 Thread rob stone
Hello, PostgreSQL 11.6 (Debian 11.6-2~sid1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 9.2.1-21) 9.2.1 20191130, 64-bit Is there something awry with the pg_prepared_statements view? This is the only row found and it is NOT created by the application. namestatement prepare_time