pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: John A Meinel <john@arbash-meinel.com>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: PG8 Tuning
Date: Tue, 16 Aug 2005 22:27:20 -0400
Message-ID: <10092.1124245640@sss.pgh.pa.us> (raw)
In-Reply-To: <43027361.2070303@arbash-meinel.com>
References: <1536.217.45.209.171.1123763001.squirrel@www.gradwell.com>
	<1123836428.19976.26.camel@amd64-laptop-spoe>
	<1123779524.6664.1.camel@toonses.gghcwest.com>
	<200508160912.32263.josh@agliodbs.com>
	<20050816162531.GB32695@alvh.no-ip.org>
	<43021567.1000101@arbash-meinel.com>
	<7516.1124232599@sss.pgh.pa.us>
	<43027361.2070303@arbash-meinel.com>

John A Meinel <john@arbash-meinel.com> writes:
> So pg_xlog is really only needed for a dirty shutdown. So what about the
> idea of having pg_xlog on a ramdisk that is syncronized periodically to
> a real disk.

Well, if "periodically" means "at every transaction commit", that's
pretty much what we do now.

			regards, tom lane

view thread (19+ messages)  latest in thread

Message-ID: <10092.1124245640@sss.pgh.pa.us>
Permalink:  ../10092.1124245640@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/10092.1124245640@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, john@arbash-meinel.com
  Subject: Re: PG8 Tuning
  In-Reply-To: <10092.1124245640@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox