| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Greg Stark <stark(at)mit(dot)edu> |
| Cc: | maciek(at)heroku(dot)com, PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #8656: Duplicate data violating unique constraints |
| Date: | 2013-12-20 10:19:38 |
| Message-ID: | 20131220101938.GA29697@alap2.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 2013-12-20 00:19:16 +0000, Greg Stark wrote:
> On Wed, Dec 4, 2013 at 8:04 PM, <maciek(at)heroku(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Umesh Kirdat | 2013-12-20 11:38:55 | Duplicate key violates unique constraint |
| Previous Message | peters | 2013-12-20 03:09:54 | BUG #8687: HashAggregate runs out of memory |