[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
|
| Список | 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
Id increase work_mem setting, to avoid on-disk sorting.
Regards,
Igor Neyman
В списке pgsql-general по дате отправления: