On 17-Oct-06, at 3:05 PM, Behl, Rohit ((Infosys)) wrote: HiWe are facing performance problems in postgres while executing a query. When I execute this query on the server it takes 5-10 seconds. Also I get good performance while executing this query from my code in java with the hard codes values.
Rohit_Behl wrote:
Hi
I made the following changes to the conf file:
enable_indexscan = true
enable_seqscan = false
We also have a large amount of data being inserted into our tables. I was just
wondering if this could have an impact on the inserts since I guess this change
is on the
On 10/18/06, Heikki Linnakangas [EMAIL PROTECTED] wrote:
I would suggest using setting prepareThreshold=0 in the JDBC driver
connection URL, or calling pstmt.setPrepareThreshold(0) in the
application. That tells the driver not to use server-side prepare, and
the query will be re-planned every
On 10/18/06, Tom Lane [EMAIL PROTECTED] wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
this is not really a jdbc issue, just a practical problem with
prepared statements...
Specifically, that the OP is running a 7.4 backend, which was our
first venture into prepared parameterized statements.
Hi Merlin
I have disabled seq-scan and now it works like a charm. Thanks it was a saver.
Regards
Rohit
On 10/18/06, Bucky Jordan [EMAIL PROTECTED] wrote:
On 10/17/06, Rohit_Behl [EMAIL PROTECTED] wrote:
Select events.event_id, ctrl.real_name, events.tsds, events.value,
Hi
We are facing performance problems in postgres while executing a query. When I
execute this query on the server it takes 5-10 seconds. Also I get good
performance while executing this query from my code in java with the hard codes
values. I face severe performance problems when I run it
-Original Message-
From: [EMAIL PROTECTED]
[mailto:pgsql-performance-
[EMAIL PROTECTED] On Behalf Of Merlin Moncure
Sent: Tuesday, October 17, 2006 4:29 PM
To: Rohit_Behl
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Jdbc/postgres performance
On 10/17/06
On 10/18/06, Bucky Jordan [EMAIL PROTECTED] wrote:
On 10/17/06, Rohit_Behl [EMAIL PROTECTED] wrote:
Select events.event_id, ctrl.real_name, events.tsds, events.value,
events.lds, events.correction, ctrl.type, ctrl.freq from table events,
iso_midw_control ctrl where events.obj_id =
Merlin Moncure [EMAIL PROTECTED] writes:
this is not really a jdbc issue, just a practical problem with
prepared statements...
Specifically, that the OP is running a 7.4 backend, which was our
first venture into prepared parameterized statements. PG 8.1 will
do better, 8.2 should do better