* Thomas Heller <th(dot)heller(at)comtron(dot)net> [001121 14:59] wrote:
> Hi all!
> I wonder if there is any possibilty to boost the performance of my
> postgresql machine. I used to have it running on a dual p3-450 + 512mb ram
> (with apache/php on the same machine). Recently I moved it to a new machine,
> p3-800 + 512mb ram, and moved the apache to another machine.
> Now the performance is somewhat BAD. The load of the machine is arround
> 10.00 and the postmaster processes are taking all of the machines cpu power.
> I don't have correct stats to my hand but the web server is currently
> handling something about 220.000 page impressions per day (220.000 page
> calls which open a php -> db connection running at least 1 query).
> I didn't went to deep into query optimization yet cause I didn't read enough
> about that now. So I tried adjusting the command line options ....
> What are the best values to use for sort_mem and shmem_buffers?
> I'm currently starting the service with
> -B 256
> -N 48
> -o '-F -S 512'
> This seems NOT to be the right value but I don't know it what way I can
> experiment with them?
> If somebody has some tips handy i'd like to hear them.
I have a gig of ram and use:
-o "-F -S 65534"
maybe if you halve those values...
you may also need to vacuum the database.
What OS are you running?
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."
In response to
pgsql-admin by date
|Next:||From: Dronamraju Rajesh||Date: 2000-11-22 14:52:09|
|Subject: vacuum....errors...killing my PRODUCTION servers|
|Previous:||From: Thomas Heller||Date: 2000-11-21 22:54:09|
|Subject: Lack of Performance|