| From: | "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru> |
|---|---|
| To: | Melanie Plageman <melanieplageman(at)gmail(dot)com> |
| Cc: | Junwang Zhao <zhjwpku(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
| Subject: | Re: Using read_stream in index vacuum |
| Date: | 2024-10-23 13:32:21 |
| Message-ID: | 89E23A2B-7184-4A84-BDBD-1A5EE36AB4F1@yandex-team.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> On 22 Oct 2024, at 16:42, Melanie Plageman <melanieplageman(at)gmail(dot)com> wrote:
>
> Ah, right, the callback might return InvalidBlockNumber far before
> we've actually read (and vacuumed) the blocks it is specifying.
I've discussed the issue with Thomas on PGConf.eu and he proposed to use stream reset.
PFA v3.
Best regards, Andrey Borodin.
| Attachment | Content-Type | Size |
|---|---|---|
| v3-0001-Prototype-B-tree-vacuum-streamlineing.patch | application/octet-stream | 4.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tender Wang | 2024-10-23 13:48:11 | Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. |
| Previous Message | Alastair Turner | 2024-10-23 13:25:06 | Re: Proposal for Integrating Data Masking and anonymization into PostgreSQL |