Insufficient system resources for PostgreSQL 7.4.x?

From: Jiří Němec <konference(at)menea(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: Insufficient system resources for PostgreSQL 7.4.x?
Date: 2005-01-14 12:19:53
Message-ID: 1303876210.20050114131953@menea.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I changed DB server assigned for developing PHP applications, from
MySQL to PostgreSQL.

- Celeron 566Mhz
- 128MB DDR 266MHz
- HDD 20GB Seagate 7200rpm
- Apache 2.0.52
- PHP 4.3.10
- PostgreSQL 7.4.6

But a problem occured. PHP scripts end due fatal errors "Fatal error:
Maximum execution time of 30 seconds exceeded...". When I had used
MySQL there were no problems with similat queries. These queries work
with 20 records tables, so I think, problem is somewhere else.

Is necessary to upgrade HW or I can try to downgrade Apache, PHP and
PostgreSQL but I don't know if is solution...

Thank you very much for your replies.

--
Jiri Nemec

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2005-01-14 12:26:07 Re: pl/pgsql trigger: syntax error at or near "ELSEIF"
Previous Message Roman Neuhauser 2005-01-14 12:06:25 pl/pgsql trigger: syntax error at or near "ELSEIF"