Re: bad performance on Solaris 10

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>, Chris Mair <list(at)1006(dot)org>
Subject: Re: bad performance on Solaris 10
Date: 2006-04-04 06:09:43
Message-ID: 200604032309.44143.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message C Storm 2006-04-04 07:24:42 pgmemcache
Previous Message Mark Kirkwood 2006-04-04 05:12:04 Re: bad performance on Solaris 10