Re: Vacuum

From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: SOzcn <selahattinozcnma(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Vacuum
Date: 2024-01-03 11:08:14
Message-ID: CAJk5AtbnYbQh7nuZBvL4qNFT1nWU_ZAEGXFKC0_tT46rKQasMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Vacuum removes dead tuples in primary. Are you saying, dead tuples are
removed in replica?

On Wed, 3 Jan 2024, 15:53 Laurenz Albe, <laurenz(dot)albe(at)cybertec(dot)at> wrote:

> On Wed, 2024-01-03 at 01:22 +0530, Rajesh Kumar wrote:
> > Vacuum operation happens only in primary. How is that replicated?
>
> VACUUM modifies data, data modifications are WAL logged, the WAL
> is replayed on the standby.
>
> Yours,
> Laurenz Albe
>

In response to

  • Re: Vacuum at 2024-01-03 10:23:24 from Laurenz Albe

Responses

  • Re: Vacuum at 2024-01-03 15:08:08 from Ron Johnson
  • Re: Vacuum at 2024-01-03 15:11:57 from David G. Johnston
  • Re: Vacuum at 2024-01-03 18:36:48 from Laurenz Albe

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-01-03 15:08:08 Re: Vacuum
Previous Message Laurenz Albe 2024-01-03 10:23:24 Re: Vacuum