| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Avoiding bloat in CIC |
| Date: | 2017-02-28 13:19:12 |
| Message-ID: | CANP8+jJhHgWQJti41v7KADwQbV+ADya-a91MBvYwvdpGdb1qsQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
In CREATE INDEX CONCURRENTLY it seems possible to release the index
build snapshot early, so we can reset our xmin before we complete the
sort and write the main part of the index.
Patch to implement this attached.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| avoid_bloat_from_cic.v1.patch | application/octet-stream | 3.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Steele | 2017-02-28 13:21:18 | Re: Backend crash on non-exclusive backup cancel |
| Previous Message | Tom Lane | 2017-02-28 13:17:17 | Re: Statement-level rollback |