Re: Re: 7.1 performance - Mailing list pgsql-admin

From Thomas Heller
Subject Re: Re: 7.1 performance
Date
Msg-id 9cp50j$e5o$1@news.tht.net
Whole thread Raw
In response to RE: Re: 7.1 performance  ("Blake, Stephen" <Stephen.Blake@veritect.com>)
List 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



pgsql-admin by date:

Previous
From: "Christian Anton"
Date:
Subject: URGENT HELP NEEDED
Next
From: "Brian Z"
Date:
Subject: Primary Keys