Skip site navigation (1) Skip section navigation (2)

postgresql-8.1-413.jdbc3.jar ignoring setPrepareThreshold();

From: Jeremiah Jahn <jeremiah(at)goodinassociates(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: postgresql-8.1-413.jdbc3.jar ignoring setPrepareThreshold();
Date: 2008-12-18 16:53:40
Message-ID: 1229619221.1933.11.camel@bluejay.goodinassociates.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
I have slight problem on a postgresql-server-8.1.11-1PGDG.rhel4 db.
The first statement below runs fine. But the second two statements
return no results. When these statement are not run as prepared
statements they work fine. I need to run them as a prepared statement
because of the parameterization, but I don't want the server to cache
the prepared nature of the statements. These statements worked fine on
an old 7.3 driver. The only differendce I could see was that the driver
didn't prepare them.




Dec 18 10:10:56 devel postgres[5404]: [2-1] LOG:  duration: 362.004 ms  statement: EXECUTE <unnamed>  [PREPARE:    select aggregationvalue.value as
Dec 18 10:10:56 devel postgres[5404]: [2-2]  aggregationvalue$value,aggregationvalue.aggregatetype as aggregationvalue$aggregatetype,aggregationvalue.count as
Dec 18 10:10:56 devel postgres[5404]: [2-3]  aggregationvalue$count,aggregationvalue.stoptime as aggregationvalue$stoptime,aggregationvalue.starttime as
Dec 18 10:10:56 devel postgres[5404]: [2-4]  aggregationvalue$starttime from aggregationvalue where  date_trunc('month', aggregationvalue.stoptime) between $1 and $2  and
Dec 18 10:10:56 devel postgres[5404]: [2-5]  aggregationvalue.aggregatetype = $3 and  split_part(aggregationvalue.value,':',1) = $4  and 
Dec 18 10:10:56 devel postgres[5404]: [2-6]  split_part(aggregationvalue.value,':',2) like $5  and  split_part(aggregationvalue.value,':',3) like $6  ]

Dec 18 10:11:05 devel postgres[5404]: [4-1] LOG:  duration: 31.000 ms  statement: EXECUTE <unnamed>  [PREPARE:    select aggregationvalue.value as
Dec 18 10:11:05 devel postgres[5404]: [4-2]  aggregationvalue$value,aggregationvalue.aggregatetype as aggregationvalue$aggregatetype,aggregationvalue.count as
Dec 18 10:11:05 devel postgres[5404]: [4-3]  aggregationvalue$count,aggregationvalue.stoptime as aggregationvalue$stoptime,aggregationvalue.starttime as
Dec 18 10:11:05 devel postgres[5404]: [4-4]  aggregationvalue$starttime from aggregationvalue where  date_trunc('month', aggregationvalue.stoptime) between $1 and $2  and
Dec 18 10:11:05 devel postgres[5404]: [4-5]  aggregationvalue.aggregatetype = $3 and  split_part(aggregationvalue.value,':',1) = $4  and 
Dec 18 10:11:05 devel postgres[5404]: [4-6]  split_part(aggregationvalue.value,':',2) like $5  and  split_part(aggregationvalue.value,':',3) like $6  ]

Dec 18 10:11:05 devel postgres[5404]: [6-1] LOG:  duration: 2.000 ms  statement: EXECUTE <unnamed>  [PREPARE:    select aggregationvalue.value as
Dec 18 10:11:05 devel postgres[5404]: [6-2]  aggregationvalue$value,aggregationvalue.aggregatetype as aggregationvalue$aggregatetype,aggregationvalue.count as
Dec 18 10:11:05 devel postgres[5404]: [6-3]  aggregationvalue$count,aggregationvalue.stoptime as aggregationvalue$stoptime,aggregationvalue.starttime as
Dec 18 10:11:05 devel postgres[5404]: [6-4]  aggregationvalue$starttime from aggregationvalue where  date_trunc('day', aggregationvalue.stoptime) between $1 and $2  and
Dec 18 10:11:05 devel postgres[5404]: [6-5]  aggregationvalue.aggregatetype = $3 and  split_part(aggregationvalue.value,':',1) = $4  and 
Dec 18 10:11:05 devel postgres[5404]: [6-6]  split_part(aggregationvalue.value,':',2) like $5  and  split_part(aggregationvalue.value,':',3) like $6  ]





The sum of the Universe is zero.

pgsql-jdbc by date

Next:From: Jeremiah JahnDate: 2008-12-18 17:22:07
Subject: postgresql-8.1-413.jdbc3.jar ignoring setPrepareThreshold();
Previous:From: JAlexoidDate: 2008-12-18 10:24:32
Subject: Re: ResultSet performance question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group