| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Arsalan Zaidi <azaidi(at)directi(dot)com> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Turning off transactions completely. |
| Date: | 2002-01-07 17:55:01 |
| Message-ID: | 200201071755.g07Ht1c02709@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I found a comment from 1999 where someone asked a similiar Q and Mimijian
> responded that that was not possible in pg. Is that still true? Can it be
> easily changed in the code?
It is possible to turn off transactions. The problem is would the
system be any faster, and would a single INSERT failure due to a
constraint check make the system unusable. You can turn off fsync in
postgresql.conf and maybe there is a way to prevent pre-change image
logging to WAL, but other than that, I can't think of any more speedups
that keep the system usable.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gyozo Papp | 2002-01-07 17:55:33 | REQUEST: database security issues in PHP manual |
| Previous Message | Stephan Szabo | 2002-01-07 17:51:57 | Re: How to cast a char[] to varchar? |