Hacker News new | ask | show | jobs
by bjornsing 701 days ago
> 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.)