Re: Memory Usage and OpenBSD

Jeff Ross wrote:
> Hopefully if I can get it to run well under pgbench the same setup
> will work well with drupal.  The site I was worried about when I went
> to this bigger server has started a little slower than originally
> projected so the old server is handling the load.

The standard TPC-B-like test pgbench runs is not even remotely like what
Drupal will do on your server.  It's almost a write-only test--the few
things that are read in are also being written.

I'd suggest you explore pgbench using the "-S" flag (or what
pgbench-tools calls select.sql) to generate select-only loads at various
sizes and client counts to get an idea what your server is going to do
on loads more like a web application.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us