Re: PG8 Tuning - Mailing list pgsql-performance

From Tom Lane
Subject Re: PG8 Tuning
Date
Msg-id 10092.1124245640@sss.pgh.pa.us
Whole thread Raw
In response to Re: PG8 Tuning  (John A Meinel <john@arbash-meinel.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Anjan Dave"
Date:
Subject: Re: choosing RAID level for xlogs
Next
From: Alex Turner
Date:
Subject: Re: choosing RAID level for xlogs