Re: Re: Re: disable wal

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Re: Re: disable wal
Дата
Msg-id 200105022007.f42K7pw25558@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Re: disable wal  (Anuradha Ratnaweera <anuradha@gnu.org>)
Список pgsql-admin
>
> 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@postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Restoring a pg_dump fails with
Следующее
От: Jaume Teixi
Дата:
Сообщение: best plase to put custom .so modules