From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | mbc(at)soliton(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: clarification of postgres limitations |
Date: | 2004-03-04 13:19:28 |
Message-ID: | 200403041319.28860.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thursday 04 March 2004 12:35, mbc(at)soliton(dot)com wrote:
>
> Limitations of PostgreSQL
> Maximum size for a database unlimited (4 TB databases exist)
> Maximum size for a table 16 TB on all operating systems
> Since it seems that the location of the server's data store is bound to a
> single directory, a database cannot span across multiple file systems.
> Further, does it imply that the maxiumum size of a database cannot exceed
> the maximum size of the underlying file system?
If you're planning on having a database larger than your file-system supports,
you might want to consider a different file-system. However...
Each object (table, index) is stored in a separate file (more than one if
split at 1GB). Some people use symlinks to move various files/directories to
different locations. For example, to move the write-ahead-log to a different
set of disks from the main DB files.
Tablespaces are being worked on at the moment, so there is a good chance they
will be in 7.5
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2004-03-04 14:04:07 | Re: META: Filtering viruses/worms |
Previous Message | Richard Huxton | 2004-03-04 13:14:36 | Re: Are Postgres 7.4.1 RPMs available for SuSE 9.0 ? |