| From: | Horák Daniel <horak(at)sitmp(dot)cz> |
|---|---|
| To: | Jiří Němec <konference(at)menea(dot)cz>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Insufficient system resources for PostgreSQL 7.4.x? |
| Date: | 2005-01-14 12:49:14 |
| Message-ID: | 66EFFC1A2B0A424E87D68EC10B1F458D040928@EXCH2.plzen-city.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgresql | 2005-01-14 13:37:34 | Re: Functions returning RECORD |
| Previous Message | Alban Hertroys | 2005-01-14 12:30:34 | Re: Insufficient system resources for PostgreSQL 7.4.x? |