Re: archives frequently do not load today's messages

On Wed, 2 Sept 2026 at 21:47, Nathan Bossart <nathandbossart(at)gmail(dot)com>
wrote:

> I've been noticing $subject for a while. For example, navigating to
> today's messages for pgsql-hackers@ [0] intermittently shows me nothing
> for
> long stretches of time. My suspicion is that this has something to do with
> the increased cache time patch committed back in March [1].
>
> [0] https://www.postgresql.org/list/pgsql-hackers/since/202609020000/
> [1]
> https://git.postgresql.org/gitweb/?p=pgarchives.git;a=commitdiff;h=c151a8

You're on the right track, but that's not the actual bug. But the
increasing of the cache time has exposed a bug that has been there all
along.

The bug is that *someone* hits the URL, in this case for Sep 2, when there
are zero messages from Sep 2 yet. When that happens the empty page is
cached but it's cached *without* the key that say it's in September. So
when the first Sep 2 message actually arrives, it failes to to purge it
because it purges everything in September only. Not in NULL.

I've pushed a fix for this now, I think (
https://git.postgresql.org/gitweb/?p=pgarchives.git;a=commit;h=51485f825d7012fc5701900c2dfd562609fb1a06
).

It will take up to 12 hours for all the incorrectly taggred pages to expire
from the cache.

Thanks for the report!

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>