Re: Postgres Performance

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Postgres Performance
Дата
Msg-id 20080320103615.GA10677@depesz.com
обсуждение исходный текст
Ответ на Postgres Performance  (Aftab Alam <aalam@tsrdarashaw.com>)
Список pgsql-admin
On Thu, Mar 20, 2008 at 04:02:48PM +0530, Aftab Alam wrote:
> I have mistaken written 7.0 instead of 7.3, I am getting more than 2000 hits
> daily, can u suggest the best configuration. Mean while I am trying to
> migrate it to 8.3.1

7.3 is also pretty old.
as for 2000 hits daily - it's not much. do you have performance issues?
check which queries couse the problems, and "explain analyze" them.
then, with explain analyze output, you can fix performance issues in
those queries.

regards,

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

В списке pgsql-admin по дате отправления:

Предыдущее
От: Aftab Alam
Дата:
Сообщение: Re: Postgres Performance
Следующее
От: Vishal Arora
Дата:
Сообщение: Re: Postgres Performance