From: Dinko Yaksic <dinko@ssi.cl>
To: pgsql-php@postgresql.org
Subject: Apache timeouts
Date: Tue, 23 Apr 2002 19:25:23 -0400
Message-ID: <1019604323.3cc5ed63aa4a6@webmail.ssi.cl> (raw)
Hi!
I'm using a server with Redhat 7.2, Apache 1.3.22, Php 4.0.6 & PostgreSQL
7.1.3.
PROBLEM:
When I execute a long PostgreSQL query via PHP code (involves joining 12
tables), I can't access any other webpage of the server while is processing the
query & displaying the results (opening a new webpage causes that remains blank
until the classic "page not found" appears).
SYNTOMPS:
Doing a 'top' shows postmaster has 98% of the processor. The strange fact
is the frontend (psql) lets do another queries in the meanwhile, but Apache
won't display any other page of the server until the whole query and page
displays finishes. That behaviour is catastrophic for the rest of the users,
moreover when the query takes almost 1 minute.
MEASURES:
I've already applied many optimizations like vacuuming before, and adding
the indexes for the primaries & foreign keys involved, and the ones from the
article http://www.phpbuilder.com/columns/smith20010821.php3 (128MB in shm_max).
I'm not using persistent connections to the db, and I'm allowing 32
connections on postgresql.conf (max_connections) & php.ini (pgsql.max_links).
Any suggestion how to solve the "greedy behaviour" of the web server ?
Thanx in advance, Dinko
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: dinko@ssi.cl
Subject: Re: Apache timeouts
In-Reply-To: <1019604323.3cc5ed63aa4a6@webmail.ssi.cl>
References: <1019604323.3cc5ed63aa4a6@webmail.ssi.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox