| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jeff Ross <jross(at)wykids(dot)org> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, Anton Maksimenkov <anton200(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Subject: | Re: Memory Usage and OpenBSD |
| Date: | 2010-02-13 18:17:25 |
| Message-ID: | 4B76ECB5.2010608@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Janet S Jacobsen | 2010-02-13 18:58:10 | Re: "could not read block 0... " error followed by "database does not exist" |
| Previous Message | Jeff Ross | 2010-02-13 17:36:28 | Re: Memory Usage and OpenBSD |