Hi
Thanks everybody. I have confirmed that this does not affect inserts. But the query performance has improved a lot.
Regards
Rohit
-----Original Message-----
From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Heikki
Linnakangas
Sent: 18 October 2006 13:52
To: 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 large amount of data being inserted into our tables. I was just wondering if this could have an impact
onthe inserts since I guess this change is on the database.
enable_seqscan shouldn't affect plain inserts, but it will affect
*every* query in the system.
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 time you execute it with the real
values of the parameters.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you
arenot the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not
tocopy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This
e-mailmay contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for
anydamage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before
openingthe e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to
orfrom this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***