Postgres Pro
Downloads
Home   >   mailing lists

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

From Ivan Fabris, Gruppo ColliniConsulting.it
Subject [GENERAL] R: advice for efresh of materialized view
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A0817DC8C776C@W2008DC01.ColliniConsulting.lan
Whole thread Raw
In response to Re: [GENERAL] advice for efresh of materialized view  (Igor Neyman <ineyman@perceptron.com>)
Responses Re: [GENERAL] advice for efresh of materialized view  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-general
Tree view
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
 
 

Da: Igor Neyman [mailto:ineyman@perceptron.com]
Inviato: mercoledì 12 aprile 2017 15:59
A: Ivan Fabris, Gruppo ColliniConsulting.it; 'pgsql-general@postgresql.org'
Oggetto: RE: advice for efresh of materialized view

  

 ____________________________________________________________________________________________________

 

Also, in regards to:

 

         Sort Method: external merge  Disk: 287784kB

 

I’d increase work_mem setting, to avoid on-disk sorting.

 

Regards,

Igor Neyman

 

 

 

 

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] dynamic schema modeling and performance
Next
From: Igor Neyman
Date:
Subject: Re: [GENERAL] advice for efresh of materialized view