Re: Where do a novice do to make it run faster?

Поиск
Список
Период
Сортировка
От Claus Guttesen
Тема Re: Where do a novice do to make it run faster?
Дата
Msg-id b41c75520804280919l4548b749r45b68ef870ff7329@mail.gmail.com
обсуждение исходный текст
Ответ на Where do a novice do to make it run faster?  ("A B" <gentosaker@gmail.com>)
Список pgsql-performance
>  1) hardware
>  2) rewriting my queries and table structures
>  3) using more predefined queries
>  4) tweek parameters in the db conf files
>
>  Of these points:
>  1) is nothing I can do about right now, but in the future perhaps.
>  2) will be quite hard right now since there is more code than time.
>  3) almost like 2 but perhaps more do-able with the current constraints.
>  4) This seems to be the easiest one to start with...
>
>  So what should I do/read concerning point 4?
>  If you have other good suggestions  I'd be very interested in that.
>
>  Thank you :-)

You can provide information postgresql-version, what type of queries
you're running, some explain analyze of those, and what type of
hardware you're running and what OS is installed.

--
regards
Claus

When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.

Shakespeare

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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: shared_buffer/DRBD performances
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Replication Syatem