Re: Sketch of a fix for that truncation data corruption issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Sketch of a fix for that truncation data corruption issue
Date: 2023-04-03 12:40:41
Message-ID: 1199755.1680525641@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> Has this problem been fixed? I was under the impression that it had
> been, but I spent some 20 minutes now looking for code, commits, or
> patches in the archives, and I can't find anything relevant. Maybe it
> was fixed in some different way that's not so obviously connected?

As far as I can see from a quick look at the code, nothing has been
done that would alleviate this problem: smgrtruncate still calls
DropRelationBuffers before truncating.

Have you run into a new case of it? I don't recall having seen
many field complaints about this since 2018.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2023-04-03 12:45:53 Re: GUC for temporarily disabling event triggers
Previous Message Aleksander Alekseev 2023-04-03 12:33:28 Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound