Re: PostgreSQL as a local in-memory cache

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: PostgreSQL as a local in-memory cache
Дата
Msg-id AANLkTimxDE1PRSaIhLFqRfaXoG7zxbDNH9mQO4aK4Kkt@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL as a local in-memory cache  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: PostgreSQL as a local in-memory cache  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Wed, Jun 23, 2010 at 9:25 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Wed, Jun 23, 2010 at 3:37 PM, Bruce Momjian <bruce@momjian.us> wrote:
>> Tom Lane wrote:
>>> Dimitri Fontaine <dfontaine@hi-media.com> writes:
>>> > Josh Berkus <josh@agliodbs.com> writes:
>>> >> a) Eliminate WAL logging entirely
>>
>> If we elimiate WAL logging, that means a reinstall is required for even
>> a postmaster crash, which is a new non-durable behavior.
>>
>> Also, we just added wal_level = minimal, which might end up being a poor
>> name choice of we want wal_level = off in PG 9.1.  Perhaps we should
>> have used wal_level = crash_safe in 9.0.
>>
>> I have added the following TODO:
>>
>>        Consider a non-crash-safe wal_level that eliminates WAL activity
>>
>>            * http://archives.postgresql.org/pgsql-performance/2010-06/msg00300.php
>
> I don't think we need a system-wide setting for that.  I believe that
> the unlogged tables I'm working on will handle that case.

Aren't they going to be truncated at startup? If the entire system is
running without WAL, we would only need to do that in case of an
unclean shutdown wouldn't we?


--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: PostgreSQL as a local in-memory cache
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: PostgreSQL as a local in-memory cache