Re: disable wal

Поиск
Список
Период
Сортировка
От Oliver Vecernik
Тема Re: disable wal
Дата
Msg-id 3AED9E58.3B76031@aon.at
обсуждение исходный текст
Ответ на Re: disable wal  (Anuradha Ratnaweera <anuradha@gnu.org>)
Список pgsql-admin
Anuradha Ratnaweera wrote:
>
> On Mon, 30 Apr 2001, Oliver Vecernik wrote:
>
> > Anuradha Ratnaweera wrote:
> > >
> > > Is there a way to disable write ahead logging (WAL) in 7.1?
> >
> > Why do you want to do this?
> >
>
> Because I have a copy of my real server on a laptop and I do all the
> development on it. I use pg_dumpall, diff and shell scripts to synchronize
> the two databases, source code and mails.
>
> Obviously, I don't want the data on the laptop to be reliable because even
> if everything corrupts there, a fresh installation and a single run of the
> sync scripts will take things back to normal. These scripts will _not_
> corrupt the real server even if the data on the laptop is corrupt because
> data is taken only _from_ the server and not the other way round.
>
> WAL files seem to be a bottleneck for the laptop performance (not on the
> real server). So I want to disable it on the laptop.

If you don't need the other new features of 7.1 (outer joins, ...) you
can stick to 7.0.3.

Regards,
Oliver

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: datetimeField = datetimeField - '30minutes'::timespan in psql 7.0 or above
Следующее
От: "G. Anthony Reina"
Дата:
Сообщение: How to change the table owner?