Re: Re: disable wal

Поиск
Список
Период
Сортировка
От Anuradha Ratnaweera
Тема Re: Re: disable wal
Дата
Msg-id Pine.LNX.4.21.0105020112210.533-100000@presario
обсуждение исходный текст
Ответ на Re: Re: disable wal  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Re: Re: disable wal
Список 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?

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
>


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

Предыдущее
От: Reiner Dassing
Дата:
Сообщение: Re: Restoring a pg_dump fails with
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Restoring a pg_dump fails with