Re: Avoiding Refreezing XIDs Repeatedly

From: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
To: bkrug <bkrug(at)usatech(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Avoiding Refreezing XIDs Repeatedly
Date: 2015-02-09 18:56:04
Message-ID: CAJghg4LziRUuHKhuiqLjW0fuoop6kZA_CSuqx+=ZrU7gyuwKhw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Feb 9, 2015 at 4:45 PM, bkrug <bkrug(at)usatech(dot)com> wrote:

> Should the relfrozenxid of pg_class then equal 2 for very old and already
> vacuumed tables? Because that is not what I am seeing.

hm... You meant in the entire table? Like an static table?

Then no, it is done tuple by tuple only. In older versions (I think up to
9.2) it was setting xmin column to 2.

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message bkrug 2015-02-09 19:07:05 Re: Avoiding Refreezing XIDs Repeatedly
Previous Message Alvaro Herrera 2015-02-09 18:53:05 Re: Avoiding Refreezing XIDs Repeatedly