Postgres Pro
Downloads
Home   >   mailing lists

PGSQL 9.3 - Materialized View - multithreading - Mailing list pgsql-performance

From Nicolas Paris
Subject PGSQL 9.3 - Materialized View - multithreading
Date
Msg-id CA+ssMOS8kjy+YKMV+hR5VTuLSa-Fd-ADHVgsNBaEaXS44Azwiw@mail.gmail.com
Whole thread Raw
Responses Re: PGSQL 9.3 - Materialized View - multithreading
Re: PGSQL 9.3 - Materialized View - multithreading
List pgsql-performance
Tree view
Hello,

My question is about multiprocess and materialized View.
http://www.postgresql.org/docs/9.3/static/sql-creatematerializedview.html
I (will) have something like 3600 materialised views, and I would like to know the way to refresh them in a multithread way
(anderstand 8 cpu cores -> 8 refresh process  in the same time)


Thanks a lot,

pgsql-performance by date:

Previous
From: Varadharajan Mukundan
Date:
Subject: Fwd: Slow Count-Distinct Query
Next
From: Thom Brown
Date:
Subject: Re: PGSQL 9.3 - Materialized View - multithreading