Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Shared buffers, db transactions commited, and write IO on Solaris
- From: Josh Berkus <josh(at)agliodbs(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Cc: Dimitri <dimitrik(dot)fr(at)gmail(dot)com>, "Erik Jones" <erik(at)myemma(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Subject: Re: Shared buffers, db transactions commited, and write IO on Solaris
- Date: Thu, 29 Mar 2007 17:23:23 -0700
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
- Follow-Ups:
- References:
- Prev by Date: Re: Planner doing seqscan before indexed join
- Next by Date: Re: Sunfire X4500 recommendations
- Previous by thread: Re: Shared buffers, db transactions commited, and write IO on Solaris
- Next by thread: Re: Shared buffers, db transactions commited, and write IO on Solaris
- Indexes: