Home > Enterprise >  How to know the data files state?
How to know the data files state?

Time:03-26

I tried to look into data dictionary of postgresql for long time but i didn't help.

I'm trying to know what state is the data file in, is it available for the db instance or not

photo with example

enter image description here

I tryed to look into pg_class table

CodePudding user response:

Postgres does not have the concept of "online" (or "offline") data files.

When you create a table it creates a file for that table. For every GB of data, Postgres will add a new file. If you drop the table all files belonging to that table are removed.

So the files for a table are always "online".

For more details on how Postgres stores the data, I recommend reading the chapter Database Physical Storage in the manual.

Or read The Internals of PostgreSQL - Chapter 1: Database Cluster, Databases, and Tables

  • Related