Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: PostgreSQL as a local in-memory cache
Date
Msg-id AANLkTinyzvzA3mGTQEM1eYY0K818qi0M_q19aY_pDViq@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL as a local in-memory cache  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Low perfomance SUM and Group by large databse
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: raid10 write performance