PGSQL 9.3 - Materialized View - multithreading

From: Nicolas Paris <niparisco(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: PGSQL 9.3 - Materialized View - multithreading
Date: 2014-04-04 16:29:42
Message-ID: CA+ssMOS8kjy+YKMV+hR5VTuLSa-Fd-ADHVgsNBaEaXS44Azwiw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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,

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Thom Brown 2014-04-04 16:54:07 Re: PGSQL 9.3 - Materialized View - multithreading
Previous Message Hans Drexler 2014-04-04 12:00:31 Batch update query performance