Re: BRIN summarization vs. WAL logging

2022-01-27 Thread Tomas Vondra
On 1/26/22 19:14, Alvaro Herrera wrote: On 2022-Jan-26, Robert Haas wrote: On Tue, Jan 25, 2022 at 10:12 PM Tomas Vondra wrote: 2) brin_summarize_range() Now, the issue I think is more serious, more likely to happen, and harder to fix. When summarizing a range, we write two WAL records:

Re: BRIN summarization vs. WAL logging

2022-01-26 Thread Alvaro Herrera
On 2022-Jan-26, Robert Haas wrote: > On Tue, Jan 25, 2022 at 10:12 PM Tomas Vondra > wrote: > > 2) brin_summarize_range() > > > > Now, the issue I think is more serious, more likely to happen, and > > harder to fix. When summarizing a range, we write two WAL records: > > > > INSERT heapBlk 2 pag

Re: BRIN summarization vs. WAL logging

2022-01-26 Thread Robert Haas
On Tue, Jan 25, 2022 at 10:12 PM Tomas Vondra wrote: > 1) brin_desummarize_range() > > But if the cluster/VM/... crashes right after you ran the function (and > it completed just fine, possibly even in an explicit transaciton), that > change will get lost. Not really a serious data corruption/loss