Re: CHECKPOINT unlogged data

From: Christoph Berg <myon(at)debian(dot)org>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: CHECKPOINT unlogged data
Date: 2025-06-11 13:45:46
Message-ID: aEmIijETyhj9DsWG@msg.df7cb.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Re: Nathan Bossart
> That seems like a good idea to me. I'm tempted to say that "fast" more
> accurately describes what's happening than "immediate." "Immediate" sounds
> like it happens instantaneously, but it's actually just happening "fast,"
> i.e., as fast as possible.

Ack.

> > #define CHECKPOINT_FLUSH_ALL 0x0010 /* Flush all pages, including those
> > * belonging to unlogged tables */
> >
> > Maybe CHECKPOINT_FLUSH_UNLOGGED would be more explicit?
>
> WFM.

Do we want to change the checkpoint log message (and the new options)
only, or include the CHECKPOINT_* flags? (I would guess there aren't
many external users of these flags, but mmmv.)

> I thought it would make sense to put it closer to where these options are
> described, since it'll be most evident for manually-initiated checkpoints.

Ack, I'll add that.

> >> We might also want to make sure it's clear that CHECKPOINT does nothing if
> >> there's been no database activity since the last one (or, in the case of a
> >> restartpoint, if there hasn't been a checkpoint record).
> >
> > That's taken care of by "force":
> >
> > #define CHECKPOINT_FORCE 0x0008 /* Force even if no activity */
>
> Oh, I see that we always specify that for CHECKPOINT commands, except for
> restartpoints. IIRC even if you do specify CHECKPOINT_FORCE for a
> restartpoint, it'll have no effect. It's proably worth mentioning that
> case, at least.

Right, will do.

Christoph

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rahila Syed 2025-06-11 13:45:56 Re: add function for creating/attaching hash table in DSM registry
Previous Message jian he 2025-06-11 13:22:22 Re: Add SPLIT PARTITION/MERGE PARTITIONS commands