Postgres Pro
Downloads
Home   >   mailing lists

Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery? - Mailing list pgsql-general

From Wen Yi
Subject Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery?
Date
Msg-id TYAP286MB0636B44B4E48FA2AAF65DE72A9BE9@TYAP286MB0636.JPNP286.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
I am a student who are interesting in database kernel.When I am reviewing my database course,a question make me confused.

In file system,if a error happen when I insert some data into data saving system,the whole data exists will be broken and can't recovery anymore.

But when I check the code in postgres,I found the postgres also use the write function(That! is a UNIX file system api)

My question is:

Since it's all built on top of the file system,why it always make sure that the postgres better than common csv file storage in disaster recovery?

Thanks in advance!

pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: AIX and EAGAIN on open()
Next
From: Adrian Klaver
Date:
Subject: Re: Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery?