Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] advice for efresh of materialized view - Mailing list pgsql-general

From Igor Neyman
Subject Re: [GENERAL] advice for efresh of materialized view
Date
Msg-id DM5PR07MB2810F8EB8F23A2390296BB1ADA030@DM5PR07MB2810.namprd07.prod.outlook.com
Whole thread Raw
In response to [GENERAL] R: advice for efresh of materialized view  ("Ivan Fabris, Gruppo ColliniConsulting.it" <Fabris@colliniconsulting.it>)
List pgsql-general
Tree view

 

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 by date:

Previous
From: "Ivan Fabris, Gruppo ColliniConsulting.it"
Date:
Subject: [GENERAL] R: advice for efresh of materialized view
Next
From: Osahon Oduware
Date:
Subject: [GENERAL] Error During PostGIS Build From Source on Linux