| From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
|---|---|
| To: | "Ivan Fabris, Gruppo ColliniConsulting(dot)it" <Fabris(at)colliniconsulting(dot)it>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: advice for efresh of materialized view |
| Date: | 2017-04-12 15:35:28 |
| Message-ID: | DM5PR07MB2810F8EB8F23A2390296BB1ADA030@DM5PR07MB2810.namprd07.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Ivan Fabris, Gruppo ColliniConsulting.it
Sent: Wednesday, April 12, 2017 11:17 AM
To: 'pgsql-general(at)postgresql(dot)org' <pgsql-general(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Osahon Oduware | 2017-04-12 17:14:19 | Error During PostGIS Build From Source on Linux |
| Previous Message | Ivan Fabris, Gruppo ColliniConsulting.it | 2017-04-12 15:16:47 | R: advice for efresh of materialized view |