Re: About the limit of storage

From: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
To: Sean <seanatpurdue(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: About the limit of storage
Date: 2010-05-02 16:04:06
Message-ID: u2ne94e14cd1005020904n25b7997xb20a6b038775280a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/5/2 Sean <seanatpurdue(at)hotmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gordon Shannon 2010-05-02 16:30:07 Re: Tracking down log segment corruption
Previous Message John Gage 2010-05-02 15:02:39 Re: Order of execution in shell echo to psql