postgresql query cost values/estimates

Поиск
Список
Период
Сортировка
От John Lister
Тема postgresql query cost values/estimates
Дата
Msg-id 5006A991.3020504@kickstone.com
обсуждение исходный текст
Список pgsql-performance
Hi, I was wondering if there are any recommended ways or tools for
calculating the planner cost constants? Also, do the absolute values
matter or is it simply the ratio between them? I'm about to configure a
new server and can probably do a rough job of calculating them based on
supposed speeds of the various components but wondered if anyone uses
more accurate methods?

Thanks

John

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

Предыдущее
От: Sergey Konoplev
Дата:
Сообщение: Re: Process 11812 still waiting for ExclusiveLock on extension of relation
Следующее
От: "Campbell, Lance"
Дата:
Сообщение: monitoring suggestions