| From: | Matthias van de Meent <boekewurm(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Instability in test/regress/sql/portals.sql |
| Date: | 2026-03-11 14:11:36 |
| Message-ID: | CAEze2Wi0hg46bcvLQrjid6Kvbb+NSR1N5OKbDNfHy2J=JutJ=Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
Internally at Databricks we've seen rare regression failures in the
portals.sql test, where the regression diff looks something like the
one attached in data_attachments_ed2b37649a9393b5.diffs.
It seems like this was caused by synchronized seqscans, which caused
the foo25ns cursor to start its seqscan not at the start of the table,
but instead with an offset into the table. This changed the output,
because that relied on the seqscan starting at the first page of the
table.
To stabilize this test, let's add SET synchronize_seqscans = off, as attached.
Kind regards,
Matthias van de Meent
Databricks (https://www.databricks.com)
| Attachment | Content-Type | Size |
|---|---|---|
| data_attachments_ed2b37649a9393b5.diffs | application/octet-stream | 2.9 KB |
| v1-0001-Stabilize-syncscan-issue-in-pg_regress-portals.ou.patch | application/octet-stream | 1.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2026-03-11 14:24:05 | Re: Exit walsender before confirming remote flush in logical replication |
| Previous Message | shihao zhong | 2026-03-11 14:10:32 | Re: Add missing stats_reset column to pg_stat_database_conflicts view |