Re: CHECKPOINT unlogged data

Fujii Masao <masao.fujii@oss.nttdata.com>

From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: Nathan Bossart <nathandbossart@gmail.com>, Christoph Berg <myon@debian.org>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, Andres Freund <andres@anarazel.de>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-07-10T04:01:43Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Add FLUSH_UNLOGGED option to CHECKPOINT command.

  2. Add MODE option to CHECKPOINT command.

  3. Add option list to CHECKPOINT command.

  4. Rename CHECKPOINT_FLUSH_ALL to CHECKPOINT_FLUSH_UNLOGGED.

  5. Rename CHECKPOINT_IMMEDIATE to CHECKPOINT_FAST.


On 2025/07/10 4:26, Nathan Bossart wrote:
> Here is what I have staged for commit, which I'm planning to do on Friday.

Thanks for updating the patches!

Regarding the 0005 patch:

-			COMPLETE_WITH("MODE");
+			COMPLETE_WITH("MODE, FLUSH_UNLOGGED");

Shouldn't that be:

     COMPLETE_WITH("MODE", "FLUSH_UNLOGGED");

IOW, the two options should be separate strings, so it needs
double quotes around each.

Regards,

-- 
Fujii Masao
NTT DATA Japan Corporation