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.
Title: Jdbc/postgres performance
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 per
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,
> >
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 stat
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 ever
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 databas
know.
Thanks
Regards
Rohit
From: Rohit_Behl
Sent: Wed 18/10/2006 11:10
To: Merlin Moncure
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Jdbc/postgres performance
Hi Merlin
I have disabled seq-scan and now it works like a charm. Thanks it was a
"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 bette
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 = c
> -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 perform
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 = ctrl.obj_id and events.event_id > ?::bigint order by
events.e
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 us
12 matches
Mail list logo
