Re: Benchmarking

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