Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBJBl4m85087; Wed, 19 Dec 2001 06:47:05 -0500 (EST) (envelope-from martin@bugs.unl.edu.ar) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id F3833FD25; Wed, 19 Dec 2001 08:45:36 -0300 (GMT) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 36A6CFD1C; Wed, 19 Dec 2001 08:45:30 -0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: Gurudutt , pgsql-php@postgresql.org Subject: Re: Maximum Execution Timeout Error!! Date: Wed, 19 Dec 2001 08:45:27 -0300 X-Mailer: KMail [version 1.3.2] Cc: pgsql-sql@postgresql.org References: <4419501758.20011219145851@indvalley.com> In-Reply-To: <4419501758.20011219145851@indvalley.com> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20011219114530.36A6CFD1C@bugs.unl.edu.ar> X-Virus-Scanned: by AMaViS snapshot-20011031 X-Archive-Number: 200112/23 X-Sequence-Number: 798 On Mié 19 Dic 2001 06:28, Gurudutt wrote: > Hello, > > I am using POSTGRESQL Version 7.1.3 and PHP to implement a call center > software. We have real -time updations and querying on the database > almost every 30 seconds. > > I am using PEAR DB to realize data abstraction layer. > > I am regularly doing VACUUM ANALYZE. I don't know what is making the > system to be very slow, but it takes nearly a minute plus execution > time to do simple fetch operations. > > How do I make the system, to perform much faster. Optimize the options in your postmaster.conf file? Buy better hardware? > Sometimes I also get the following error.. > > ------- ERROR STARTS------ > > Fatal error: Maximum execution time of 30 seconds exceeded in DB/pgsql.php > on line 163 > > ------- ERROR ENDS------ You have to change the configuration of PHP. Read your php.ini file. Saludos... :-) -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------