Postgres Pro
Downloads
Home   >   mailing lists

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

From Greg Smith
Subject Re: PostgreSQL as a local in-memory cache
Date
Msg-id 4C1A7EAB.3020202@2ndquadrant.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 
Josh Berkus wrote:
> a) Eliminate WAL logging entirely
> c) Turn off the background writer

Note that if you turn off full_page_writes and set
bgwriter_lru_maxpages=0, you'd get a substantial move in both these
directions without touching any code.  Would help prove those as useful
directions to move toward or not.  The difference in WAL writes just
after a checkpoint in particular, due to the full_page_writes behavior,
is a significant portion of total WAL activity on most systems.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL as a local in-memory cache
Next
From: "Pierre C"
Date:
Subject: Re: PostgreSQL as a local in-memory cache