Document / automate creating lightweight snapshot on the same filesystem for durablilty

[ideoma]

Is your feature request related to a problem?

There are users who want to run QuestDB on unstable hardware where power can be randomly reset. That can be

industrial uses where the DB runs on Raspberry Pi or similar on equipment or machinery Windows users who run the DB at home can suffer from random software updates and domestic power issues. Sometimes these users are OK to sacrifice a small portion of their data like 1 hour or 15 mins in the even of hard power reset but keep running the DB in async mode.

Describe the solution you'd like.

Document or automate the creation of lightweight checkpoints on the same file system using hard links so that users can implement this mechanism.

Describe alternatives you've considered.

No response

Full Name:

Alex Pelagenko

Affiliation:

QuestDB

Additional context

Related to https://github.com/questdb/questdb/issues/4829