pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Maximum Execution Timeout Error!!
3+ messages / 3 participants
[nested] [flat]

* Maximum Execution Timeout Error!!
@ 2001-12-19 09:28 Gurudutt <guru@indvalley.com>
  2001-12-19 11:45 ` Re: Maximum Execution Timeout Error!! Martín Marqués <martin@bugs.unl.edu.ar>
  2001-12-19 12:23 ` Re: [SQL] Maximum Execution Timeout Error!! Radu-Adrian Popescu <radu.popescu@aldratech.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Gurudutt @ 2001-12-19 09:28 UTC (permalink / raw)
  To: pgsql-php@postgresql.org; +Cc: pgsql-sql

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.

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------

  

-- 
Best regards,
 Gurudutt                          mailto:guru@indvalley.com

Life is not fair - get used to it.
Bill Gates




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Maximum Execution Timeout Error!!
  2001-12-19 09:28 Maximum Execution Timeout Error!! Gurudutt <guru@indvalley.com>
@ 2001-12-19 11:45 ` Martín Marqués <martin@bugs.unl.edu.ar>
  1 sibling, 0 replies; 3+ messages in thread

From: Martín Marqués @ 2001-12-19 11:45 UTC (permalink / raw)
  To: Gurudutt <guru@indvalley.com>; pgsql-php@postgresql.org; +Cc: pgsql-sql

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
-----------------------------------------------------------------



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] Maximum Execution Timeout Error!!
  2001-12-19 09:28 Maximum Execution Timeout Error!! Gurudutt <guru@indvalley.com>
@ 2001-12-19 12:23 ` Radu-Adrian Popescu <radu.popescu@aldratech.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Radu-Adrian Popescu @ 2001-12-19 12:23 UTC (permalink / raw)
  To: Gurudutt <guru@indvalley.com>; pgsql-php@postgresql.org; +Cc: pgsql-sql

Regarding the 30" timeout, you should edit your php.ini and modify the line
that reads

max_execution_time = 30

Also try to human-optimize your queries, use EXPLAIN to analyse you query
plans, throw in some indexes, bla-bla-bla.
You should be able to get more help when providing some pieces of code/db
structures/EXPLAIN outputs etc.
Good luck till then.

--

Radu-Adrian Popescu
CSA, DBA, Programmer
Aldratech

----- Original Message -----
From: "Gurudutt" <guru@indvalley.com>
To: <pgsql-php@postgresql.org>
Cc: <pgsql-sql@postgresql.org>
Sent: Wednesday, December 19, 2001 11:28
Subject: [SQL] Maximum Execution Timeout Error!!


> 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.
>
> 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------
>
>
>
> --
> Best regards,
>  Gurudutt                          mailto:guru@indvalley.com
>
> Life is not fair - get used to it.
> Bill Gates
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-12-19 12:23 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-12-19 09:28 Maximum Execution Timeout Error!! Gurudutt <guru@indvalley.com>
2001-12-19 11:45 ` Martín Marqués <martin@bugs.unl.edu.ar>
2001-12-19 12:23 ` Radu-Adrian Popescu <radu.popescu@aldratech.com>

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