[GENERAL] R: advice for efresh of materialized view

Поиск
Список
Период
Сортировка
От Ivan Fabris, Gruppo ColliniConsulting.it
Тема [GENERAL] R: advice for efresh of materialized view
Дата
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A0817DC8C776C@W2008DC01.ColliniConsulting.lan
обсуждение исходный текст
Ответ на Re: [GENERAL] advice for efresh of materialized view  (Igor Neyman <ineyman@perceptron.com>)
Ответы Re: [GENERAL] advice for efresh of materialized view  (Igor Neyman <ineyman@perceptron.com>)
Список pgsql-general
Дерево обсуждения
Thank you very much, I followed both of your advice, plus adding some extra ram, and the excution time dropped from 10 to 2 minutes.
Since I did everything with one shot, I can't tell the weight of every single action.....
Regards
 
IF
 
 

Da: Igor Neyman [mailto:ineyman@perceptron.com]
Inviato: mercoledì 12 aprile 2017 15:59
A: Ivan Fabris, Gruppo ColliniConsulting.it; 'pgsql-general@postgresql.org'
Oggetto: RE: advice for efresh of materialized view

  

 ____________________________________________________________________________________________________

 

Also, in regards to:

 

         Sort Method: external merge  Disk: 287784kB

 

I’d increase work_mem setting, to avoid on-disk sorting.

 

Regards,

Igor Neyman

 

 

 

 

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: [GENERAL] dynamic schema modeling and performance
Следующее
От: Igor Neyman
Дата:
Сообщение: Re: [GENERAL] advice for efresh of materialized view