Re: BUG #8656: Duplicate data violating unique constraints - Mailing list pgsql-bugs

On 2013-12-20 00:19:16 +0000, Greg Stark wrote:
> On Wed, Dec 4, 2013 at 8:04 PM,  <maciek@heroku.com> wrote:
> >     "post_col2_col3_idx" btree (col2, col3) CLUSTER
>
> Andres, would cluster trigger the same MultiXactId freezing problem?

Yes, but IIRC, it wouldn't trigger the problems in this specific cluster
unless somebody changed vacuum_freeze_min_age since the cluster was
younger than that when the problem first occurered. Check
vacuum_set_xid_limits() for details.

Nice observation about the CLUSTER in there.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services