Large tables management question

From: Luben Karavelov <luben(at)bgone(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Large tables management question
Date: 2001-12-04 10:24:04
Message-ID: 20011204122404.A7712@bgone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I am designing an information system for image processing. I decided to
base it on PostgreSQL because of its advanced object-relational
features. The database will grow 200M per day or in another numbers 40G per
year.

I want to ask you if there is some way to manage such amount of data in
postgresql? This means to add additional disc to databasa storage when
the first is full, to split some of the tables over multiple discs etc?
Or I have to manage this with another means, for example on OS level
(linear raid) or on application level (to store the large data files on
filesystem).
I am asking for something similar to "merge" tables in mysql although this
is not the best silution.

Thanks in advance
luben

--
_________________________________________________________
Luben Karavelov [phone] +359 2 9877088
Network Administrator [ICQ#] 34741625
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Thornton 2001-12-04 11:57:42 Re: update returns 1, but no changes have been made
Previous Message Thomas T. Thai 2001-12-04 09:13:08 sum up rows of BITs