| From: | solai v <solai(dot)cdac(at)gmail(dot)com> |
|---|---|
| To: | Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> |
| Cc: | Ma Xueting <ma(at)sraoss(dot)co(dot)jp>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [PATCH] Report no unpinned buffers as insufficient resources |
| Date: | 2026-10-14 11:56:34 |
| Message-ID: | CAF0whufghi7dkQtaNz2HZ8+2C3-AX_PZZ5Y3Vy2rWj=0jkFw_A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
I tested the patch by reproducing the issue before and after applying
the changes.
Before applying the patch, I was able to reproduce the issue by
setting shared_buffers = 128kB and running pgbench with 16 clients and
16 threads.
The server reported no unpinned buffers available with SQLSTATE XX000.
After applying the patch, I repeated the same test and confirmed that
the error was reported with SQLSTATE 53000 (insufficient resources),
as expected.
I also ran the regression tests, and all tests passed. git diff
--check reported no issues.
The patch looks good to me. It reports the error with the appropriate
SQLSTATE while keeping the existing error message unchanged.
Thanks for the patch.
Regards,
solai
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Naylor | 2026-10-14 12:03:22 | Re: BUG #19597: getQuadrant: impossible case is reachable |
| Previous Message | Alena Rybakina | 2026-10-14 11:50:42 | Re: Vacuum statistics |