Re: [GENERAL] advice for efresh of materialized view
| От | Igor Neyman |
|---|---|
| Тема | Re: [GENERAL] advice for efresh of materialized view |
| Дата | |
| Msg-id | DM5PR07MB2810F8EB8F23A2390296BB1ADA030@DM5PR07MB2810.namprd07.prod.outlook.com обсуждение исходный текст |
| Ответ на | [GENERAL] R: advice for efresh of materialized view ("Ivan Fabris, Gruppo ColliniConsulting.it" <Fabris@colliniconsulting.it>) |
| Список | pgsql-general |
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Ivan Fabris, Gruppo ColliniConsulting.it
Sent: Wednesday, April 12, 2017 11:17 AM
To: 'pgsql-general@postgresql.org' <pgsql-general@postgresql.org>
Subject: [GENERAL] R: advice for efresh of materialized view
Attention: This email was sent from someone outside of Perceptron. Always exercise caution when opening attachments or clicking links from unknown senders or when receiving unexpected emails.
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
You can always run EXPLAIN ANALYZE and see what’s going on.
Also, it could show possibilities for improvement.
Igor Neyman
В списке pgsql-general по дате отправления: