Re: Disable Transaction - plans ?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Ben-Nes Michael <miki(at)canaan(dot)co(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Disable Transaction - plans ?
Date: 2001-10-24 10:58:36
Message-ID: 20011024205836.B2991@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 24, 2001 at 12:32:06PM +0200, Ben-Nes Michael wrote:
> Simple.
>
> In my dynamic sites I have sessions tables that get select/update/insert
> allot, So removing as many obstacles from select/update/insert against "very
> simple" tables will improve the performance.

Well, I think you may be barking up the wrong tree. The overhead for
transactions is very low. You are under the impression that that
transactions slow the database down?

Removing transactions would basically remove the whole point of having an
RDBMS. Seriously, transactions are no performance impediment.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org>
http://svana.org/kleptog/
> Magnetism, electricity and motion are like a three-for-two special offer:
> if you have two of them, the third one comes free.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vince Vielhaber 2001-10-24 11:33:09 Re: poor with mirrors
Previous Message wayne 2001-10-24 10:58:13 Re: Listing users