vacuum on streaming replication

From: Alex Samad <alex(at)samad(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: vacuum on streaming replication
Date: 2017-07-31 02:15:33
Message-ID: CAJ+Q1PW1osad7ajd4vZXK5rt-6JZka3GqoaG9m1OE8tUwAP2Vw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

setup a cluster, with streaming replication and hot stand by

the idea is to use the stand by to do queries whilst the primary is doing
inserts.

But I noticed the stats on the stand by server don't update, nor can I run
vacuum against it as its in recovery mode.

So how do update the stats and how will it affect my queries ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2017-07-31 04:13:59 Re: Invalid byte sequence for encoding UTF-8 0xc3\n
Previous Message Alex Samad 2017-07-31 02:13:51 Re: partitioning question