From: | Frank Alberto Rodriguez <franknigth(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Materialize view in slave server |
Date: | 2019-04-01 15:32:03 |
Message-ID: | 1870914.oP4ivU0TkW@frodriguez-hp-notebook |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello. If you planned to writes over materialized views, you should use the
primary server, because the slave must be to read only.
If you want to avoid writes in the slave, use normal views instead, otherwise
ensure the writes over a materialized view occur in a primary node only, but
reading it on slave node would not be a problem.
Regards
On lunes, 1 de abril de 2019 09:02:13 CST Mahmoud Moharam wrote:
> Hello All ,
> hope every thing is well with you all ,
> I planned to run stream replication (primary / slave) on my environment ,
> and want to make writes on primary and reads from slave , so the question
> is :- I have Materialize view running on primary , what is the best choose
> to run Materialize view on primary or on slave ?
>
> thanks all
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2019-04-01 21:37:50 | Re: Materialize view in slave server |
Previous Message | Mahmoud Moharam | 2019-04-01 15:02:13 | Materialize view in slave server |