- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Archived Discussions
Effective March 31st, we will no longer engage on PostgresRocks.
How to engage with us further?
- Thought Leadership: EDB Blogs
- Tips and Tricks: Postgres Tutorials
- Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket
- Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi @neiljo10,
The data file size limit in postgres is 1GB, once it reaches this size, it creates a new files with names as <oid>.1, <oid>.2.
The data files are stored in the <data_directory>/base/<database_oid>/<table_oid> location, so if the limit execeeds, the files will be like :
<data_directory>/base/<database_oid>/<table_oid>
<data_directory>/base/<database_oid>/<table_oid>.1
<data_directory>/base/<database_oid>/<table_oid>.2
...
..
.. so on
Please let us know if you have any queries on this.
Regards,
Sudhir
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi @neiljo10,
The data file size limit in postgres is 1GB, once it reaches this size, it creates a new files with names as <oid>.1, <oid>.2.
The data files are stored in the <data_directory>/base/<database_oid>/<table_oid> location, so if the limit execeeds, the files will be like :
<data_directory>/base/<database_oid>/<table_oid>
<data_directory>/base/<database_oid>/<table_oid>.1
<data_directory>/base/<database_oid>/<table_oid>.2
...
..
.. so on
Please let us know if you have any queries on this.
Regards,
Sudhir
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: PostGreSQL datafile
So does the appending happens automatically or any command is required for it ?
Is there any size limit to a database or table ?
Is there anyway we can extend this limit from 1GB ?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: PostGreSQL datafile
Hi @neiljo10,
Please refer answers to your queries :
1) So does the appending happens automatically or any command is required for it ?
- It happens automatically, postgres takes care of it internally.
2) Is there any size limit to a database or table ?
- The Databse size is unlimited and tables size is 32TB maximum. However, these are subjected disk space, memory, refer below link :
3) Is there anyway we can extend this limit from 1GB ?
- You can extend the data files size only at the building of the Postgres, i.e. building/installing it from the source code, using --withsegsize option, refer below link :
https://postgrespro.com/docs/postgresql/9.5/install-procedure
Regards,
Sudhir