Re: Parse more than bind and execute when connect to database by jdbc

On 2013-11-18 11:39, Amit Kapila wrote:
> On Mon, Nov 18, 2013 at 7:32 AM,  <wangshuo@highgo.com.cn> wrote:
>> Hi hackers,
>>
>>             I used jdbc to connect to PostgreSQL ,and I found parse 
>> nearly three
>>             times of bind and execute.Is is normaly?
>     Actually bind and execute should be more than parse. Have you
> confirmed that by enabling Log/Debug messages on server or you are
> referring to JDBC log?
>

Thanks for your reply.

This is the Log/Debug messages.
Some configuration options are as follows:
     log_min_duration_statement = 0'     log_statement = 'all'     log_line_prefix = '%t [%p]: [%l-1] db=%d,user=%u
[%x]'    logging_collector = on
 


>> What factors may cause this result?
> I am really not sure of JDBC, but from Libpq or general concept wise,
> it can happen only if someone does call parse multiple times, but 
> then
> execute only few of the statements.

I do agree with you. But I don't know what query can call parse 
multiple times.
Could you give me more information or example about this case？

     Wang Shuo     HighGo Software Co.,Ltd.     November 18, 2013