Hi,
I use jdbc to create index on a table, the sql of 'create index' cost about 30 minutes.
Finally I found, the jdbc client thread blocked at PrepareStatement.execute(), not finished.
At server side, query pg_stat_activity, the connection state already be ‘idle’ (index creation finished).
Is there any suggestion? How to deal with the client thread blocking (read for a response message?) and connection leak.
Thanks a lot.