Point-in-time recovery in Firestore

[@workaccount-s4q]

We need a more indepth video on how to use the rest api to get the PITR data info

[@joalzamora]

They hope to make a chapter that explains the correct way to export data from subcollections and how to recover them correctly.

[@hucklebackgolf]

Are there any documents or videos on the new disaster recovery backups? I'd like to know how to locate the backups or at least verify that the new setting is doing anything. I'd also like to know how to restore those backups for development DB. Documentation is behind and I can't afford the support that you have to purchase to talk to anybody.

[@graemeprentice4213]

The cost of writing a document is 18 cents per 100,000 documents and PITR storage is also 18 cents per GB per month. Since document size is usually much less than the 1MB limit, lets say average 10K document size, if you write that document 100,000 times in a month (1GB of PITR storage) the document write cost is the same as the PITR storage cost. Reading the document 100,000 times is 12 cents for egress and 6c for reading - the same as the write cost, but normally there are many more reads than writes and document average size is probably less than 1K making the PITR cost not very significant compared to read/write costs.

[@carlospero4516]

When this originally previewed, it allowed stale reads at any second within the last hour. Was that aspect removed for GA? Might still be mentioned in docs here or there, but hasn’t been pointed out in recent announcements.

[@pianoman16]

the java example she gave showed units of seconds and nanoseconds

A price calculator for this feature would be interesting.

[@matt.mcquin]

Agreed, this sounds extremely expensive for larger databases with frequent updates

[@pianoman16]

@@matt.mcquin The cost of writing a document is 18 cents per 100,000 documents and PITR storage is also 18 cents per GB per month. Since document size is usually much less than the 1MB limit, lets say average 10K document size, if you write that document 100,000 times in a month (1GB of PITR storage) the document write cost is the same as the PITR storage cost. Reading the document 100,000 times is 12 cents for egress and 6c for reading - the same as the write cost, but normally there are many more reads than writes and document average size is probably less than 1K making the PITR cost not very significant compared to read/write costs.

[@pianoman16]

@@matt.mcquin The cost of writing a document is 18 cents per 100,000 documents and PITR storage is also 18 cents per GB per month. Since document size is usually much less than the 1MB limit, lets say average 10K document size, if you write that document 100,000 times in a month (1GB of PITR storage) the document write cost is the same as the PITR storage cost. Reading the document 100,000 times is 12 cents for egress and 6c for reading - the same as the write cost, but normally there are many more reads than writes and document average size is probably less than 1K making the PITR cost not very significant compared to read/write costs.

[@Ahmed66910]

Great, waiting for UAE Firestore region