Re: Avoiding Refreezing XIDs Repeatedly

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

 




On Mon, Feb 9, 2015 at 4:45 PM, bkrug <bkrug@xxxxxxxxxxx> 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


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

  Powered by Linux