Re: What's difference among insert/write/flush lsn?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Jinhua Luo <luajit(dot)io(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: What's difference among insert/write/flush lsn?
Date: 2020-03-07 23:24:56
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Sat, Feb 1, 2020 at 11:18:42AM +0800, Jinhua Luo wrote:
> Hi,
> pg_current_wal_flush_lsn()pg_lsnGet current write-ahead log flush location
> pg_current_wal_insert_lsn()pg_lsnGet current write-ahead log insert location
> pg_current_wal_lsn()pg_lsnGet current write-ahead log write location
> I guess write is about how many bytes written in shared cache, and
> flush is flush to file, which makes it persistent.
> Anybody gives some official explanation?

I think the insert location is where data is being added to WAL, the
write location is where it was last written to the file system, and
flush is the last time is was flushed to storage.

Bruce Momjian <bruce(at)momjian(dot)us>

+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2020-03-07 23:42:16 Re: Bug in pg_restore with EventTrigger in parallel mode
Previous Message Dave Cramer 2020-03-07 23:18:38 Re: Binary support for pgoutput plugin