Re: Insufficient system resources for PostgreSQL 7.4.x? - Mailing list pgsql-general

> 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