Postgres Pro
Downloads
Home   >   mailing lists

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

From Alex Samad
Subject [GENERAL] vacuum on streaming replication
Date
Msg-id CAJ+Q1PW1osad7ajd4vZXK5rt-6JZka3GqoaG9m1OE8tUwAP2Vw@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] vacuum on streaming replication  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Tree view
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 ?

pgsql-general by date:

Previous
From: Alex Samad
Date:
Subject: Re: [GENERAL] partitioning question
Next
From: Igor Korot
Date:
Subject: Re: [GENERAL] Invalid byte sequence for encoding UTF-8 0xc3\n