PG 9..5 index performance Q's

Поиск
Список
Период
Сортировка
От ghiureai
Тема PG 9..5 index performance Q's
Дата
Msg-id 582219F1.9030502@nrc-cnrc.gc.ca
обсуждение исходный текст
Ответы Re: PG 9..5 index performance Q's  (Igor Neyman <ineyman@perceptron.com>)
Список pgsql-admin
Hi List,

  running PGSQL 9.5.1 ( EL7) ,
we are seeing a issues with one of our SQL statement getting the wrong
plan once in a while ( large temp tables being generate, exec time
takes  > 3 minutes compared with fastes plan < 1 min), we want to
undestand why a new/ expensive plan is been used instead of efficient
one, there are not data changes on the tables, any tips where to look?
Second , I would like to know if when re-creating one index ( non pk )
on  a large table with already existing indexes, are  All tables
statistics  being re-generated? ( there is a way to control persistency
of old stats?)

Isabella



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

Предыдущее
От: "michael@sqlexec.com"
Дата:
Сообщение: Re: Too many Idle Connections
Следующее
От: Igor Neyman
Дата:
Сообщение: Re: PG 9..5 index performance Q's