Re: Problem with planner

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Problem with planner
Дата
Msg-id 20110809095728.GB24450@depesz.com
обсуждение исходный текст
Ответ на Re: Problem with planner  (pasman pasmański <pasman.p@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On Mon, Aug 08, 2011 at 10:01:58PM +0200, pasman pasmański wrote:
> Try to change index: objects_endings_tsz_active(state,endings_tsz)
> where state='active'.

adding new indexes on this machine is quite complicated, as it's heavily
used production system.
And the current index should be chosen by planner anyway - it is after
analyze, but then it breaks again.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

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

Предыдущее
От: "Tomas Vondra"
Дата:
Сообщение: Re: postgres table have a large number of relpages and occupied a big memory size
Следующее
От: Vivekkumar Pandey
Дата:
Сообщение: Re: postgres table have a large number of relpages and occupied a big memory size