Re: Re: 7.1 performance

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

In response to

Browse pgsql-admin by date

  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