Insufficient system resources for PostgreSQL 7.4.x?

Jiří Němec wrote:

But a problem occured. PHP scripts end due fatal errors "Fatal error:
Maximum execution time of 30 seconds exceeded...". When I had used

Looks like you got yourself an endless loop there.

Alban Hertroys.

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

It really depends on the queries, whether they use the right indexes
(can speedup from 2 hours/query to 1 minute/query), the amount of data
stored and other things. Your hardware/software shouldn't be the
problem.

Dan