Executing the same query multiple times gets slow - Mailing list pgsql-jdbc

From Blake McBride
Subject Executing the same query multiple times gets slow
Date
Msg-id CABwHSOurbLHgmvsEzTBRncvFoSt35RU1bs9jvF-287r6dDfD0Q@mail.gmail.com
Whole thread Raw
Responses Re: Executing the same query multiple times gets slow
List pgsql-jdbc
Greetings,

I have a complex query that returns about 5,000 records and only a few columns.  If I run it in psql repeatedly, it's always fast.  If I run it through JDBC it runs fast at first but then it gets real slow (> 50 seconds).  I can't understand why it would get slow after 30 runs of the exact same query.

I am running:

Linux / 64GB RAM
PostgreSQL 15.1
postgresql-42.5.4.jar

I am using a prepared statement but a new one each time even though it is the same query (there are reasons for this).

I found the line that's having the delay is:  pstat.executeQuery();

where:  PreparedStatement pstat;

Sure appreciate any pointers!

Thanks.

Blake

pgsql-jdbc by date:

Previous
From: Matthew Bellew
Date:
Subject: Parameter marker swapping in {fn timestampdiff()}
Next
From: Dave Cramer
Date:
Subject: Re: Executing the same query multiple times gets slow