Thread: Is any limitations in PostgreSQL?

Hi all,
    In the document of PostgreSQL, I can't find any
restriction of database. I want to know something as
following:
1. What's the restriction of database file? How big it
can be(for exmaple, 10TB?).

2. Is there any restriction for the record and the
document? What kind of record and document can be add
to database.

3. What's the restriction for the table and the
collection?

Thanks for any replier

Yu Jie
webpurchasing@yahoo.com

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

On Mon, Feb 28, 2005 at 07:49:54PM -0800, Yu Jie wrote:

> 1. What's the restriction of database file? How big it
> can be(for exmaple, 10TB?).

See "What is the maximum size for a row, a table, and a database?"
in the FAQ:

http://www.postgresql.org/files/documentation/faqs/FAQ.html#4.4

> 2. Is there any restriction for the record and the
> document? What kind of record and document can be add
> to database.

See the aforementioned FAQ and the "Data Types" chapter in the
documentation:

http://www.postgresql.org/docs/8.0/interactive/datatype.html

In addition to the built-in types, users can create their own types.

> 3. What's the restriction for the table and the
> collection?

See the aforementioned FAQ.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/