Postgres Pro
Downloads
Home   >   mailing lists

Curious question about physical files to store database - Mailing list pgsql-general

From Patrick Dung
Subject Curious question about physical files to store database
Date
Msg-id 1383410991.19149.YahooMailNeo@web193504.mail.sg3.yahoo.com
Whole thread Raw
Responses Re: Curious question about physical files to store database
List pgsql-general
Tree view
As I have seen, some database created or pre-allocate large physical files on the file system to as the backend of the database tablespace.

For Postgresql, I have observed that it created several files in the base and global directory.

It may be by design, what is the pros and cons of this behavior?

Thanks and regards,
Patrick

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: pg_dump with lots and lots of tables
Next
From: Adrian Klaver
Date:
Subject: Re: changing port numbers so pgbouncer can read geoserver and postgres