Re: Re: Re: disable wal

>
> I understand that that WAL is an integral part of 7.1 and "disabling" is
> not possible. I also don't want to switch back to 7.0 becuse I _DO_ need
> the new features.
>
> If I don't care for reliability (for reasons I outlined earlier in this
> thread), are there other parameters I can set to optimize for speed, such
> as wal_sync_method? I already have turned off fsync and log_connections. I
> can't turn on silent mode, because this machine is used for all testing
> purposes and messages are useful.
>
> Also, it is possible to avoid postgresql from trying to force the OS to
> write data to the disk, so that WAL writes will be in disk cache for some
> time?

Yes, as Tom said, you can use postgres -F flag to disable fsync writes,
even with WAL in 7.1.

>
> Anuradha
>
> On Mon, 30 Apr 2001, Tom Lane wrote:
>
> > There is no way to "disable WAL". However, you might try running with
> > fsync turned off if you don't care about data integrity.
> >
> > regards, tom lane
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

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