Does PostgreSQL store a database per file, similarly to SQLite?

Question

If I am correct, SQLite stores a database per file, and a file can't store more than one databases.

How does PostgreSQL store a database in terms of file(s)? Does it also store a database per file, and a file can't store more than one databases?

postgresql.org/docs/current/static/storage.html

user330315
– user330315

2018-05-07 20:48:42 +00:00
Commented May 7, 2018 at 20:48 — user330315
– user330315, Commented May 7, 2018 at 20:48

CL. · Accepted Answer · 2018-05-07 18:50:54Z

4

(SQLite uses more than one file for the rollback journal or when in WAL mode.)

The PostgreSQL database file layout is documented in its documentation:

Each table and index is stored in a separate file. For ordinary relations, these files are named after the table or index's filenode number, which can be found in pg_class.relfilenode. […] in addition to the main file (a/k/a main fork), each table and index has a free space map …, which stores information about free space available in the relation. The free space map is stored in a file named with the filenode number plus the suffix _fsm. Tables also have a visibility map, stored in a fork with the suffix _vm, to track which pages are known to have no dead tuples. […]

answered May 7, 2018 at 18:50

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Does PostgreSQL store a database per file, similarly to SQLite?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related