Re: PostgreSQL Performance issue - Mailing list pgsql-general

From Bayless Kirtley
Subject Re: PostgreSQL Performance issue
Date
Msg-id 3CE2928AB9F8455DBB91DA4B537D2BB4@dell2400
Whole thread Raw
In response to PostgreSQL Performance issue  (<A.Bhattacharya@sungard.com>)
List pgsql-general

> Thanks a lot for your help. However I am new to Postgres database
> therefore it would be nice if you can let me know how to 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 database connection 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 deleted the remainder.
Top-posting is considered bad form in mailing-lists.

Alban Hertroys

--------------------------------------------------------------------------------------------------------

Actually, top posting is considered bad form in THIS mailing list. All the
others I participate in top post regularly. That said though, it is
considered good form to post in the manner expected by the list that one is
posting to. ;-)

Bayless


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: PostgreSQL Performance issue
Next
From: Devrim GÜNDÜZ
Date:
Subject: [ANNOUNCE] Live CD based on CentOS 5.4 and PG 8.4.3 released