Re: Analyze on slave promoted.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Analyze on slave promoted.
From: Pavel Stehule <pavel.stehule@xxxxxxxxx>
Date: Thu, 26 Sep 2019 10:31:10 +0200
Cc: "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <CABnPa_j1oLm_psF3f8o5GZBoh+2acWkkARH1d6dFKQyL5Bt+tw@mail.gmail.com>
References: <CABnPa_j1oLm_psF3f8o5GZBoh+2acWkkARH1d6dFKQyL5Bt+tw@mail.gmail.com>

Hi

čt 26. 9. 2019 v 9:55 odesílatel Joao Junior <jcoj2006@xxxxxxxxx> napsal:

Hi,
Is this necessary to run analyze on a slave using streaming replication after promotion??

No - column statistics are come from master - and are persistent - promote change nothing.

Pavel

References:
- Analyze on slave promoted.
  - From: Joao Junior

Prev by Date: Analyze on slave promoted.
Next by Date: Slow pg_publication_tables with many schemas and tables
Previous by thread: Analyze on slave promoted.
Next by thread: Re: Analyze on slave promoted.
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux