Re: PostgreSQL as a local in-memory cache

From: Chris Browne
Subject: Re: PostgreSQL as a local in-memory cache
Date: ,
Msg-id: 87ocfcnqmk.fsf@cbbrowne-laptop.afilias-int.info
(view: Whole thread, Raw)
In response to: Re: PostgreSQL as a local in-memory cache  (Chris Browne)
Responses: Re: PostgreSQL as a local in-memory cache  (Jaime Casanova)
Re: PostgreSQL as a local in-memory cache  (Josh Berkus)
List: pgsql-performance

Tree view

Re: PostgreSQL as a local in-memory cache  (Chris Browne, )
 Re: PostgreSQL as a local in-memory cache  (Steve Wampler, )
  Re: PostgreSQL as a local in-memory cache  (Craig James, )
 Re: PostgreSQL as a local in-memory cache  ("", )
 Re: PostgreSQL as a local in-memory cache  (Chris Browne, )
  Re: PostgreSQL as a local in-memory cache  (Jaime Casanova, )
  Re: PostgreSQL as a local in-memory cache  (Josh Berkus, )
 Re: PostgreSQL as a local in-memory cache  ("", )
  Re: PostgreSQL as a local in-memory cache  (Mark Kirkwood, )
  Re: PostgreSQL as a local in-memory cache  ("Pierre C", )
   Re: PostgreSQL as a local in-memory cache  (Jonathan Gardner, )
  Re: PostgreSQL as a local in-memory cache  ("Pierre C", )
  Re: PostgreSQL as a local in-memory cache  (Greg Smith, )
   Re: PostgreSQL as a local in-memory cache  ("Pierre C", )
    Re: PostgreSQL as a local in-memory cache  (Jonathan Gardner, )
     Re: PostgreSQL as a local in-memory cache  ("Pierre C", )
   Re: PostgreSQL as a local in-memory cache  (Jonathan Gardner, )
  Re: PostgreSQL as a local in-memory cache  (Alvaro Herrera, )
  Re: PostgreSQL as a local in-memory cache  (Josh Berkus, )
   Re: PostgreSQL as a local in-memory cache  (Jonathan Gardner, )
    Re: PostgreSQL as a local in-memory cache  (Balkrishna Sharma, )
   Re: PostgreSQL as a local in-memory cache  (Craig James, )

 (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.
--
select 'cbbrowne' || '@' || 'cbbrowne.com';
http://cbbrowne.com/info/internet.html
"MS  apparently now  has a  team dedicated  to tracking  problems with
Linux  and publicizing them.   I guess  eventually they'll  figure out
this back fires... ;)" -- William Burrow <>


pgsql-performance by date:

From: Josh Berkus
Date:
Subject: Re: PostgreSQL as a local in-memory cache
From: Magnus Hagander
Date:
Subject: Re: Analysis Function