| From: | Victor Yegorov <vyegorov(at)gmail(dot)com> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Deleting older versions in unique indexes to avoid page splits |
| Date: | 2020-12-31 13:50:07 |
| Message-ID: | CAGnEbohgCdXz23DZSUq_YQDsf9qj1mXVK=ih-uwS9D0b+sVKaQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
чт, 31 дек. 2020 г. в 03:55, Peter Geoghegan <pg(at)bowt(dot)ie>:
> Attached is v12, which fixed bitrot against the master branch. This
> version has significant comment and documentation revisions. It is
> functionally equivalent to v11, though.
>
> I intend to commit the patch in the next couple of weeks. While it
> certainly would be nice to get a more thorough review, I don't feel
> that it is strictly necessary. The patch provides very significant
> benefits with certain workloads that have traditionally been
> considered an Achilles' heel for Postgres. Even zheap doesn't provide
> a solution to these problems. The only thing that I can think of that
> might reasonably be considered in competition with this design is
> WARM, which hasn't been under active development since 2017 (I assume
> that it has been abandoned by those involved).
>
I am planning to look into this patch in the next few days.
--
Victor Yegorov
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2020-12-31 14:18:05 | Re: Proposed patch for key managment |
| Previous Message | Alvaro Herrera | 2020-12-31 13:47:36 | support for MERGE |