Turning off transactions completely.

From: "Arsalan Zaidi" <azaidi(at)directi(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Turning off transactions completely.
Date: 2002-01-05 08:51:44
Message-ID: 009501c195c6$3673b360$4301a8c0@directi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

I'm writing a very specialised app which has absolutely NO need for
transactions. However, I have to milk every drop of performance out of it
cause I'm performing some fairly complex queries on tens of millions of
rows.

Is there any way I can completely avoid the overhead of the implicit
transaction per SQL statement? Is there some switch or some (fairly easy)
editting that can be done to the code? My transaction log files often reach
800 MB in size and I'd like to avoid the overhead if at all possible...

Thanks in advance.

--Arsalan.

-------------------------------------------------------------------
People often hate those things which they do not know, or cannot understand.
--Ali Ibn Abi Talib (AS)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tony 2002-01-05 09:45:47 Re: PostgreSQL HardWare
Previous Message Kaare Rasmussen 2002-01-05 07:53:47 Re: PostgreSQL GUI