Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] vacuum on streaming replication - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: [GENERAL] vacuum on streaming replication
Date
Msg-id 0AB97FED-499F-4DEB-9931-1B4F6C4E0376@a-kretschmer.de
Whole thread Raw
In response to [GENERAL] vacuum on streaming replication  (Alex Samad <alex@samad.com.au>)
Responses Re: [GENERAL] vacuum on streaming replication
List pgsql-general
Tree view 
On 31 July 2017 04:15:33 GMT+02:00, Alex Samad <alex@samad.com.au> wrote:
>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 ?


The standby is read only, vacuum runs on the master and replicated to the standby. Analyse as well.

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: [GENERAL] Invalid byte sequence for encoding UTF-8 0xc3\n
Next
From: Michael Paquier
Date:
Subject: Re: [GENERAL] vacuum on streaming replication