What's difference among insert/write/flush lsn? - Mailing list pgsql-hackers

From Jinhua Luo
Subject What's difference among insert/write/flush lsn?
Date
Msg-id CAAc9rOxpN=ORFhO1cx_aa-TamtJoPj2GMtZOkOz=ZA8TDvN=9A@mail.gmail.com
Whole thread Raw
Responses Re: What's difference among insert/write/flush lsn?  (Bruce Momjian <bruce@momjian.us>)
List 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



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Shared memory leak on DSM slot exhaustion
Next
From: Amit Kapila
Date:
Subject: Re: dropdb --force