Re: bad performance on Solaris 10 - Mailing list pgsql-performance

From Josh Berkus
Subject Re: bad performance on Solaris 10
Date
Msg-id 200604032309.44143.josh@agliodbs.com
Whole thread Raw
In response to Re: bad performance on Solaris 10  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-performance
Mark,

> I suspect that making a *separate* filesystem for the pg_xlog directory
> and mounting that logging + forcedirectio would be a nice way to also
> get performance while keeping the advantages of logging + file
> buffercache for the *rest* of the postgres components.
> Cheers

Yes, we tested this.  It makes a huge difference in WAL speed.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: bad performance on Solaris 10
Next
From: Vivek Khera
Date:
Subject: Re: freebsd/softupdates for data dir