| From: | Andy Pogrebnoi <andrew(dot)pogrebnoi(at)percona(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Robert Haas <robertmhaas(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> |
| Subject: | Re: Lowering the default wal_blocksize to 4K |
| Date: | 2026-02-18 13:26:24 |
| Message-ID: | CA+aWR11mKA=kFGxX++6uMAhhqzRPU72ktd9TnhbD3O8OnR_Org@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
The Windows tests are failing on `Assert("check_GUC_init(hentry->gucvar)")`
for wal_writer_flush_after [1]. It doesn't make much sense to me as both
load- and C-value for the wal_writer_flush_after GUC are the same constant:
src/backend/utils/misc/guc_parameters.dat:
{ name => 'wal_writer_flush_after', type => 'int', context => 'PGC_SIGHUP',
group => 'WAL_SETTINGS',
short_desc => 'Amount of WAL written out by WAL writer that triggers a
flush.',
flags => 'GUC_UNIT_XBLOCKS',
variable => 'WalWriterFlushAfter',
boot_val => 'DEFAULT_WAL_WRITER_FLUSH_AFTER',
min => '0',
max => 'INT_MAX',
},
src/include/postmaster/walwriter.h:
int WalWriterFlushAfter = DEFAULT_WAL_WRITER_FLUSH_AFTER;
This constant was introduced to fix the same issue [2], but I suppose no
one checked Windows builds. Windows clearly has an old 8kB value for
WalWriterFlushAfter during the check. I suppose it is something with the
CI/build. But I have zero experience with building anything for Windows, so
any tips on where to look are welcome.
*And apologies for the dreadful formatting in my previous email; the client
plays tricks on me after I hit Send.
[1] https://cirrus-ci.com/task/6286650038288384?logs=test_world#L2728-L2729
[2]
https://www.postgresql.org/message-id/CA+hUKGLNmLV=VrT==5MqnbARgx2ifRSFtdd8ofdfrdSLL3yv5A@mail.gmail.com
---
Cheers,
Andy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tushar | 2026-02-18 13:28:10 | Re: Non-text mode for pg_dumpall |
| Previous Message | Zsolt Parragi | 2026-02-18 12:50:33 | [oauth] Bug: when is shutdown_cb called? |