Skip site navigation (1) Skip section navigation (2)

Re: Lack of Performance

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: Thomas Heller <th(dot)heller(at)comtron(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Lack of Performance
Date: 2000-11-21 23:28:49
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
* 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
> -i
> -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:

-B 32768
-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 RajeshDate: 2000-11-22 14:52:09
Subject: vacuum....errors...killing my PRODUCTION servers
Previous:From: Thomas HellerDate: 2000-11-21 22:54:09
Subject: Lack of Performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group