| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tomas Vondra <tomas(at)vondra(dot)me> |
| Cc: | Bram van der Vos <bram(dot)van(dot)der(dot)vos(at)axisinto(dot)nl>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: file corruption goes undetected |
| Date: | 2026-08-06 22:09:17 |
| Message-ID: | 1460711.1786054157@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Tomas Vondra <tomas(at)vondra(dot)me> writes:
> This is expected behavior, not a bug. It'd be great to detect these
> kinds of data corruption, but data checksums can't do that (and we don't
> have other protections).
I suspect what's really happening in this example is that the query
result is produced entirely from pages in shared buffers, so we don't
notice that the underlying disk files have been clobbered. We would
notice once we have occasion to actually read the junk data.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zsolt Parragi | 2026-08-06 22:59:49 | Re: MERGE/SPLIT PARTITIONS issues/questions |
| Previous Message | Tomas Vondra | 2026-08-06 22:01:33 | Re: file corruption goes undetected |