From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@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
