Re: clarification of postgres limitations

On Thursday 04 March 2004 12:35, mbc@soliton.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