Re: cursor use vs pg_stat_statements

2023-04-06 Thread Michael Paquier
On Wed, Oct 20, 2021 at 09:53:38AM -0400, Andrew Dunstan wrote: > Try again with autocommit turned off. Sorry, I omitted that crucial > detail. Exact test code attached (name/password removed) For the same of the archives, this should be OK now under 1d477a9. See also this thread: https://www.post

Re: cursor use vs pg_stat_statements

2021-10-20 Thread Andrew Dunstan
On 10/20/21 9:02 AM, Laurenz Albe wrote: > On Tue, 2021-10-19 at 15:24 -0400, Andrew Dunstan wrote: >> The problem I'm writing about (h/t Simon Riggs for finding it) is >> illustrated by the following snippet of java: >> >>   public static void runtest(Connection conn) throws Exception { >>   

Re: cursor use vs pg_stat_statements

2021-10-20 Thread Laurenz Albe
On Tue, 2021-10-19 at 15:24 -0400, Andrew Dunstan wrote: > > The problem I'm writing about (h/t Simon Riggs for finding it) is > illustrated by the following snippet of java: > >   public static void runtest(Connection conn) throws Exception { >     Statement stmt = conn.createStatement()

cursor use vs pg_stat_statements

2021-10-19 Thread Andrew Dunstan
The problem I'm writing about (h/t Simon Riggs for finding it) is illustrated by the following snippet of java: public static void runtest(Connection conn) throws Exception { Statement stmt = conn.createStatement(); stmt.setFetchSize(10); ResultSet rs = stmt.execute