Re:Difference between running Postgres for yourself and for ...
by bjornsing on Tuesday July 23, 2024 @03:01AM
(#41043345)
> those tricks ensure that there's enough WAL entries to allow people to pick with per-second granularity
How can they ensure that? Sounds more like they ensure that people can pick point in time with minute granularity.
I’m no expert, but doesn’t postgres write a timestamp with each record in the WAL? I know that when you start postgres in recovery mode it lets you specify a timestamp you want to restore to, and I don’t think that timestamp needs to be on a WAL file boundary. (So the tricks seem weird / unnecessary to me.)
How can they ensure that? Sounds more like they ensure that people can pick point in time with minute granularity.
I’m no expert, but doesn’t postgres write a timestamp with each record in the WAL? I know that when you start postgres in recovery mode it lets you specify a timestamp you want to restore to, and I don’t think that timestamp needs to be on a WAL file boundary. (So the tricks seem weird / unnecessary to me.)