: Rohit_Behl
Cc: Merlin Moncure; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Jdbc/postgres performance
Rohit_Behl wrote:
> Hi
>
> I made the following changes to the conf file:
>
> enable_indexscan = true
>
> enable_seqscan = false
>
> We also have a
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
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
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
