Postgres Pro
Downloads
Home   >   mailing lists

RE: [EXTERNAL] Performance down with JDBC 42 - Mailing list pgsql-performance

From Abraham, Danny
Subject RE: [EXTERNAL] Performance down with JDBC 42
Date
Msg-id PH0PR02MB74463AB1493205EAB31B79448EAFA@PH0PR02MB7446.namprd02.prod.outlook.com
Whole thread Raw
In response to Re: [EXTERNAL] Performance down with JDBC 42  (Frits Hoogland <frits.hoogland@gmail.com>)
List pgsql-performance
Tree view 
Hi guys,
Thanks for the help.
I was able to recreate the problem , on the same DB, with PSQL only. No JDBC.

A plain run of a complicated query :                      50ms
A prepare and then execute of the same query:   2500ms.

The plans are different, as discussed above. The fast one is using Materialize and Memoize.

Thanks

Danny

pgsql-performance by date:

Previous
From: Philip Semanchuk
Date:
Subject: Re: Awkward Join between generate_series and long table
Next
From: Lincoln Swaine-Moore
Date:
Subject: Re: Awkward Join between generate_series and long table