From: | Joshua Hoover <joshuahoover(at)revivalhealth(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Postmaster processes running out of control? |
Date: | 2002-03-20 23:04:17 |
Message-ID: | B8BE7FA1.7498%joshuahoover@revivalhealth.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm running PostgreSQL 7.1.3 on Red Hat Linux 7.1 and believe there is a
problem with my PostgreSQL server. I have a PHP application on a separate
server accessing the PostgreSQL server. The PostgreSQL server seems to be
getting hammered, as even simple queries on indexed columns are taking
FOREVER. When I run top, here I normally see at least 50 entries similar to
these for postmaster:
19336 postgres 9 0 92960 90M 92028 S 0.0 9.0 0:18 postmaster
19341 postgres 9 0 87996 85M 87140 S 0.0 8.5 0:09 postmaster
19355 postgres 9 0 87984 85M 87112 S 11.6 8.5 0:09 postmaster
19337 postgres 9 0 87952 85M 87092 S 0.0 8.5 0:09 postmaster
The server info from top reads:
57 processes: 54 sleeping, 3 running, 0 zombie, 0 stopped
CPU states: 54.3% user, 3.7% system, 0.0% nice, 41.8% idle
Mem: 1028908K av, 346760K used, 682148K free, 93812K shrd, 8640K
buff
Swap: 1048536K av, 0K used, 1048536K free 131796K
cached
My postgresql.conf has the following changes/additions to it that change
from the default:
max_connections = 512
sort_mem = 1024
shared_buffers = 12800
I've run a vacuum on all the tables and still see the same slow responses
from the database. Does anyone have any suggestions and/or pointers?
Thank you,
Joshua Hoover
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2002-03-20 23:23:01 | Re: Notify argument? |
Previous Message | ccruise | 2002-03-20 22:20:16 | Re: BBS on postgreSQL? |