Thread: About the limit of storage
I need to have a PostgreSQL server with 10TB disk. I created a DB which contains three tables.
I understand that PostgreSQL has the following hard limit:
size per table: 32TB
size per DB: none
I wonder what I should do if the sum of my data exceed 10TB. It does not exceed any limit that PostgreSQL system imposes, but it does exceed my server's storage. Can anyone give a hint?
Thanks,
Sean
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. Learn more.
2010/5/2 Sean <seanatpurdue@hotmail.com>: > I need to have a PostgreSQL server with 10TB disk. I created a DB which > contains three tables. > > I understand that PostgreSQL has the following hard limit: > size per table: 32TB > size per DB: none > I wonder what I should do if the sum of my data exceed 10TB. It does not > exceed any limit that PostgreSQL system imposes, but it does exceed my > server's storage. Can anyone give a hint? Then you can add other storage, and make a 'tablespace' wich point to it. http://www.postgresql.org/docs/current/static/manage-ag-tablespaces.html > Thanks, > Sean > ________________________________ > Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. > Learn more. -- Cédric Villemain