Re: Shared buffers, db transactions commited, and write IO on Solaris - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Shared buffers, db transactions commited, and write IO on Solaris
Date
Msg-id 200703291723.24061.josh@agliodbs.com
Whole thread Raw
In response to Re: Shared buffers, db transactions commited, and write IO on Solaris  (Dimitri <dimitrik.fr@gmail.com>)
Responses Re: Shared buffers, db transactions commited, and write IO on Solaris  (Erik Jones <erik@myemma.com>)
List pgsql-performance
Erik,

Wow, thanks for the post.

We've just started testing the option of sizing shared_buffers bigger than
the database, and using forcedirectio in benchmarks at Sun.  So far, our
experience has been *equal* performance in that configuration, so it's
*very* interesting to see you're getting a gain.

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

pgsql-performance by date:

Previous
From: "Dave Dutcher"
Date:
Subject: Re: Planner doing seqscan before indexed join
Next
From: david@lang.hm
Date:
Subject: Re: Sunfire X4500 recommendations