Re: PostgreSQL Performance issue

On 27 Apr 2010, at 11:15, <A.Bhattacharya@sungard.com> <A.Bhattacharya@sungard.com> wrote:

> Thanks a lot for your help. However I am new to Postgres database therefore it would be nice if you can let me know
howto set autocommit off. 
> I know from psql client issuing “\set Autocommit Off” would set it off but unfortunately it doesn’t set it off.

It's a client-side setting, not a server-side one. Hence you need to turn it off in your java program, probably in the
databaseconnection settings. 

P.S. Your message was so mangled that I couldn't find which part of the original message you were referring to, so I
deletedthe remainder. Top-posting is considered bad form in mailing-lists. 

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:737,4bd6e4f110411684215286!