Re: [GENERAL] advice for efresh of materialized view

Поиск
Список
Период
Сортировка
От Igor Neyman
Тема Re: [GENERAL] advice for efresh of materialized view
Дата
Msg-id DM5PR07MB2810F8EB8F23A2390296BB1ADA030@DM5PR07MB2810.namprd07.prod.outlook.com
обсуждение исходный текст
Ответ на [GENERAL] R: advice for efresh of materialized view  ("Ivan Fabris, Gruppo ColliniConsulting.it" <Fabris@colliniconsulting.it>)
Список pgsql-general
Дерево обсуждения

 

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 по дате отправления:

Предыдущее
От: "Ivan Fabris, Gruppo ColliniConsulting.it"
Дата:
Сообщение: [GENERAL] R: advice for efresh of materialized view
Следующее
От: Osahon Oduware
Дата:
Сообщение: [GENERAL] Error During PostGIS Build From Source on Linux