From: [email protected] [mailto:[email protected]] On Behalf Of Ivan Fabris, Gruppo ColliniConsulting.it Sent: Wednesday, April 12, 2017 11:17 AM To: '[email protected]' <[email protected]> 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
