| 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: | Whole Thread | Raw Message | 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. |