From: | Aarni <aarni(dot)ruuhimaki(at)kymi(dot)com> |
---|---|
To: | "cristi" <cristi(at)dmhi(dot)ct(dot)ro> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: max capacity of postgres database |
Date: | 2003-07-01 21:16:49 |
Message-ID: | 200307020016.49909.aarni.ruuhimaki@kymi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
From:
http://www.PostgreSQL.org/docs/faqs/FAQ.html
>>>
These are the limits:
Maximum size for a database? unlimited (4 TB databases exist)
Maximum size for a table? 16 TB
Maximum size for a row? 1.6TB
Maximum size for a field? 1 GB
Maximum number of rows in a table? unlimited
Maximum number of columns in a table? 250-1600 depending on column
types
Maximum number of indexes on a table? unlimited
Of course, these are not actually unlimited, but limited to available disk
space and memory/swap space. Performance may suffer when these values get
unusually large.
The maximum table size of 16 TB does not require large file support from the
operating system. Large tables are stored as multiple 1 GB files so file
system size limits are not important.
The maximum table size and maximum number of columns can be increased if the
default block size is increased to 32k.
>>>
So, hardware is the limit ?
BR,
Aarni
On Tuesday 01 July 2003 17:36, you wrote:
> Which is the maxim of the capacity of postgres database?
> (I use very much the blobs type)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Aarni Ruuhimäki
Megative Tmi
KYMI.com
Pääsintie 26
45100 Kouvola
info(at)kymi(dot)com / aarni(dot)ruuhimaki(at)kymi(dot)com
05 - 3755 035 / 050 - 4910 037
-------------------------------
Linux RedHat 7.3. / KDE 3.0
-------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff | 2003-07-01 21:19:52 | Re: [NOVICE] jobs mailling list: pgsql-jobs@postgresql.org ? |
Previous Message | Frank Lee | 2003-07-01 20:51:09 | Re: [NOVICE] jobs mailling list: pgsql-jobs@postgresql.org ? |