Re: Re: 7.1 performance

Поиск
Список
Период
Сортировка
От Thomas Heller
Тема Re: Re: 7.1 performance
Дата
Msg-id 9cp50j$e5o$1@news.tht.net
обсуждение исходный текст
Ответ на RE: Re: 7.1 performance  ("Blake, Stephen" <Stephen.Blake@veritect.com>)
Список 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 по дате отправления:

Предыдущее
От: "Christian Anton"
Дата:
Сообщение: URGENT HELP NEEDED
Следующее
От: "Brian Z"
Дата:
Сообщение: Primary Keys