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...
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. |