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.