From: | "Thomas Heller" <maniax(at)comtron(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Re: 7.1 performance |
Date: | 2001-05-02 14:25:22 |
Message-ID: | 9cp50j$e5o$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
> Two things you should check.
>
> 1) Are you using persistent connections in your PHP scripts?
not that good for 250+ apache httpd sessions running (only serving php ...
images/static content is balanced to another server). ;) definitly no.
> 2) Are you certain your queries are utilizing the indices you have set up
> for them.
they use indices .. i'm pretty sure with it cause i didn't change any
indices as i pg_dumpall'd the db and restored it to 7.1. As said .. the
7.0.3 is laughing about the traffic (load 0.3) and the 7.1 is about to break
(load 16). No change in php conf ... the only change is the upgrade to 7.1.
hmpf (i hope the next dual p3-1ghz won't break with 7.1, i need it there
...)
cu
thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-02 14:53:59 | Re: Restoring a pg_dump fails with |
Previous Message | Reiner Dassing | 2001-05-02 14:24:37 | Re: Restoring a pg_dump fails with |