Re: PostgreSQL as a local in-memory cache

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: PostgreSQL as a local in-memory cache
Дата
Msg-id AANLkTinyzvzA3mGTQEM1eYY0K818qi0M_q19aY_pDViq@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL as a local in-memory cache  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
On Thu, Jun 17, 2010 at 1:29 PM, Josh Berkus <josh@agliodbs.com> wrote:
> a) Eliminate WAL logging entirely

In addition to global temporary tables, I am also planning to
implement unlogged tables, which are, precisely, tables for which no
WAL is written.  On restart, any such tables will be truncated.  That
should give you the ability to do this (by making all your tables
unlogged).

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Low perfomance SUM and Group by large databse
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: raid10 write performance