Re: Avoiding Refreezing XIDs Repeatedly
От
Alvaro Herrera
Тема
Re: Avoiding Refreezing XIDs Repeatedly
Дата
Msg-id
20150209191035.GG3391@alvh.no-ip.org
Ответ на
Список
Дерево обсуждения
Avoiding Refreezing XIDs Repeatedly bkrug <bkrug@usatech.com>
Re: Avoiding Refreezing XIDs Repeatedly Matheus de Oliveira <matioli.matheus@gmail.com>
Re: Avoiding Refreezing XIDs Repeatedly bkrug <bkrug@usatech.com>
Re: Avoiding Refreezing XIDs Repeatedly Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Avoiding Refreezing XIDs Repeatedly Matheus de Oliveira <matioli.matheus@gmail.com>
Re: Avoiding Refreezing XIDs Repeatedly bkrug <bkrug@usatech.com>
Re: Avoiding Refreezing XIDs Repeatedly Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Avoiding Refreezing XIDs Repeatedly Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoiding Refreezing XIDs Repeatedly Alvaro Herrera <alvherre@2ndquadrant.com>
bkrug wrote: > The problem I'm facing is that I have many large (several GB) tables that are > not being changed (they are several days old) but auto-vacuum keeps scanning > and updating them every time the xid wraps around and thus my rsync back-up > process sees that the disk files have changed and must copy them. We have considered changing this, but it needs a concerted effort. It's not a simple problem. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-performance по дате отправления
