| From: | mixo <mixo(at)beth(dot)uniforum(dot)org(dot)za> |
|---|---|
| To: | Chris Travers <chris(at)travelamericas(dot)com> |
| Cc: | "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Benchmarking |
| Date: | 2003-07-09 07:20:29 |
| Message-ID: | 3F0BC23D.4090406@beth.uniforum.org.za |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Perfomance matters the most. So, what would be the ideal setup for
permomance in
Pg?
Machine specs:
PIII 1.0 GHz
640 MB Ram
36 Gig Hd partions as follows:
/dev/sda1
linux swap 1 Gig
/dev/sda2 / 11 Gigs
/dev/sda3
/var 11 Gigs
/dev/sda4
Free 11 Gigs
/dev/sda4 is not currently mounted, so that in future when redhat has
new releases,
the insallation can be made without changing the existing installtion
Chris Travers wrote:
> Re performance tuning-- PostgreSQL is configured out of the box to
> start on just about anything. It is not configured for performance.
> If you want decent performance with many concurrent connections, try
> setting the shared_buffers to 1000 and make sure that Postgresql will
> start. That is a good place to start.
>
> Apache2 comes with a benchmarking tool called ab that I have found
> useful. I am not familiar with others.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2003-07-09 07:38:42 | Re: Restoring a postgres database |
| Previous Message | Dennis Björklund | 2003-07-09 07:15:41 | Re: Restoring a postgres database |