Re: Benchmarking

On Wednesday 09 Jul 2003 8:20 am, mixo wrote:
> 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:
[snip]

Nobody can say - will you have one concurrent user or 100? Do you have one
table with 100 rows or 50 tables with 100 million? Are you largely reading or
largely updating?

Try the following settings in postgresql.conf as a start, but that's not to
say they'll be wonderful, just not too terrible.

# shared between backends, measured in 8kB blocks
shared_buffers = 1024
# Memory *per sort* in kB
sort_mem = 1024
# This doesnt control anything, it tells PG how much disk-cache you typically
# have (see output of free / top)
effective cache_size = 10000

You'll want to test with some real data, and real usage patterns. In terms of
your hardware, more RAM or another disk or two would be what I'd spend money
on if I had to.

Once you've got some tests going and have some more information, pop over to
the performance mailing list for further discussion.
--
  Richard Huxton