Re: Postgres prepare statement caching issue in postgres command line

2021-05-23 Thread Adrian Klaver
On 5/23/21 12:04 AM, Soumya Prasad Ukil wrote: postgres=> execute parallel_execute1('a', 'b'); postgres=> execute parallel_execute2(1, 2); I have enabled pg_stats_statement chrome extension. I have enabled postgres log inside post_parse_analyze_hook and also debugging through gdb using break

Re: Postgres prepare statement caching issue in postgres command line

2021-05-23 Thread Soumya Prasad Ukil
postgres=> execute parallel_execute1('a', 'b');postgres=> execute parallel_execute2(1, 2); I have enabled pg_stats_statement chrome extension. I have enabled postgres log inside post_parse_analyze_hook  and also debugging through gdb using break point. I see it is always going through parse call

Re: Postgres prepare statement caching issue in postgres command line

2021-05-22 Thread Adrian Klaver
On 5/22/21 1:25 PM, Soumya Prasad Ukil wrote: I have been using postgres prepare statement feature through JDBC. I could see the same prepare statement multiple times, parsing is not happening in postgres backend, which is expected. However I do the same in psql command line, that does not happ

Re: Postgres prepare statement caching issue in postgres command line

2021-05-22 Thread Ron
On 5/22/21 4:11 PM, Tom Lane wrote: Soumya Prasad Ukil writes: I have been using postgres prepare statement feature through JDBC. I could see the same prepare statement multiple times, parsing is not happening in postgres backend, which is expected. However I do the same in psql command line,

Re: Postgres prepare statement caching issue in postgres command line

2021-05-22 Thread Tom Lane
Soumya Prasad Ukil writes: > I have been using postgres prepare statement feature through JDBC. I could > see the same prepare statement multiple times, parsing is not happening in > postgres backend, which is expected. However I do the same in psql command > line, that does not happen. It goes

Postgres prepare statement caching issue in postgres command line

2021-05-22 Thread Soumya Prasad Ukil
I have been using postgres prepare statement feature through JDBC. I could see the same prepare statement multiple times, parsing is not happening in postgres backend, which is expected. However I do the same in psql command line, that does not happen. It goes to parsing every time I execute Usi