Re: About the limit of storage - Mailing list pgsql-general

From Cédric Villemain
Subject Re: About the limit of storage
Date
Msg-id u2ne94e14cd1005020904n25b7997xb20a6b038775280a@mail.gmail.com
Whole thread Raw
In response to About the limit of storage  (Sean <seanatpurdue@hotmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Sean
Date:
Subject: About the limit of storage
Next
From: Gordon Shannon
Date:
Subject: Re: Tracking down log segment corruption