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

From: Jinhua Luo <luajit(dot)io(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: What's difference among insert/write/flush lsn?
Date: 2020-02-01 03:18:42
Message-ID: CAAc9rOxpN=ORFhO1cx_aa-TamtJoPj2GMtZOkOz=ZA8TDvN=9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?
Thanks.

Regards,
Jinhua Luo

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2020-02-01 05:26:37 Re: dropdb --force
Previous Message Thomas Munro 2020-02-01 02:37:03 Re: Shared memory leak on DSM slot exhaustion