Thread: About the limit of storage

About the limit of storage

From
Sean
Date:
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.

Re: About the limit of storage

From
Cédric Villemain
Date:
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