Re: PostgreSQL as a local in-memory cache

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: PostgreSQL as a local in-memory cache
Дата
Msg-id AANLkTilLIgOiCQbH7MbR19yYlk1-mD7sn7Bvbl8coBBN@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL as a local in-memory cache  (Chris Browne <cbbrowne@acm.org>)
Список pgsql-performance
On Tue, Jun 15, 2010 at 12:37 PM, Chris Browne <cbbrowne@acm.org> wrote:
> swampler@noao.edu (Steve Wampler) writes:
>> Or does losing WAL files mandate a new initdb?
>
> Losing WAL would mandate initdb, so I'd think this all fits into the
> set of stuff worth putting onto ramfs/tmpfs.  Certainly it'll all be
> significant to the performance focus.

why is that? isn't simply execute pg_resetxlog enough? specially
'cause OP doesn't care about loosing some transactions

--
Jaime Casanova         www.2ndQuadrant.com
Soporte y capacitación de PostgreSQL

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

Предыдущее
От: Yeb Havinga
Дата:
Сообщение: Re: B-Heaps
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: PostgreSQL as a local in-memory cache