Re: pg_upgrade and materialized views

From: Andres Freund <andres(at)anarazel(dot)de>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Claudio Freire <klaussfreire(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_upgrade and materialized views
Date: 2018-02-20 21:32:46
Message-ID: 20180220213246.rpyoj5tq25qmhf2m@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2018-02-20 18:26:59 -0300, Alvaro Herrera wrote:
> Claudio Freire wrote:
>
> > In the upgraded server, vacuum complained with:
> >
> > INFO: vacuuming "public.user_agents_canonical_user_agent_os"
> > vacuumdb: vacuuming of database "mat" failed: ERROR: found xmin
> > 244738497 from before relfrozenxid 245830003
>
> Wow, these checks were just added shortly before the minors released a
> couple of weeks ago, and they've already found one genuine bug! Nice.

My paranoia is vindicated once more!

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomas Vondra 2018-02-20 21:35:50 Re: Segmentation Fault in logical decoding get/peek API
Previous Message Tom Lane 2018-02-20 21:27:44 Re: pg_upgrade and materialized views