Re: PostgreSQL as a local in-memory cache - Mailing list pgsql-performance

From Jaime Casanova
Subject Re: PostgreSQL as a local in-memory cache
Date
Msg-id AANLkTilLIgOiCQbH7MbR19yYlk1-mD7sn7Bvbl8coBBN@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL as a local in-memory cache  (Chris Browne <cbbrowne@acm.org>)
List 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 by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: B-Heaps
Next
From: Josh Berkus
Date:
Subject: Re: PostgreSQL as a local in-memory cache