[no subject]

["Rohit_Behl" <Rohit_Behl(at)infosys(dot)com>]

 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(at)postgresql(dot)org [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Heikki Linnakangas
Sent: 18 October 2006 13:52
To: Rohit_Behl
Cc: Merlin Moncure; pgsql-performance(at)postgresql(dot)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 on the 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 are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from 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***