Re: Turning off transactions completely.

From: "Arsalan Zaidi" <azaidi(at)directi(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Turning off transactions completely.
Date: 2002-01-08 05:51:07
Message-ID: 00bf01c1980a$23a81f00$4301a8c0@directi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Perhaps you want MySQL ;-)

I plan to bench-mark it today. Pg performs fine for normal business use and
we're using it for our other needs, but this app is rather unusual...

>
> Seriously, transactions per se are not your problem, and you can't turn
> them off anyway, so there's no point in continuing to bark up that tree.
>

'Kay; it was just a thought.

<info about checkpoint tuning>

Am already doing this and have increased the checkpointing segs, wal files
and buffers. I no longer get any advice in the logs about increasing this...

>
> There are also the usual tuning questions about whether you've set the
> number of shared buffers to something reasonable, etc. etc.
>

Already done...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Aniket Kulkarni 2002-01-08 06:01:45 Integrating ADSM
Previous Message David Bryan 2002-01-08 04:17:33 Adding constraint to existing table.