Re: How many tables can be created in one datebase?

OK, here are some new numbers from the current FAQ:

Maximum size for a database? unlimited (500 GB 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

I just updated the max row length to 1.6 TB as you suggested.

---------------------------------------------------------------------------

Josh Jore wrote:
> Huh ok, so that pegs the max size for a row at 1.6 TB then. How do you get
> to unlimited when there is a max size per attribute and max # of
> attributes. Also, I gather that 1599 is probably a safer max attr # than
> 1600 to make room for an extra attr during UPDATE (otherwise it would max
> out during the query)
>
> Now I just can't imagine what would go into a 1.6TB row but...
>
> Joshua b. Jore ; http://www.greentechnologist.org
>
> On Thu, 11 Jul 2002, Richard Huxton wrote:
>
> > On Thursday 11 Jul 2002 9:24 am, huang(at)tanpopo-tane(dot)com wrote:
> > > How many tables can be created in one datebase?
> > > How many fields can be created in one table?
> > > thank you
> >
> > See http://www3.uk.postgresql.org/users-lounge/limitations.html
> >
> > Maximum size for a database = unlimited (60GB databases exist)
> > Maximum size for a table = 64 TB on all operating systems
> > Maximum size for a row = unlimited in 7.1 and later
> > Maximum size for a field = 1GB in 7.1 and later
> > Maximum number of rows in a table = unlimited
> > Maximum number of columns in a table = 1600
> > Maximum number of indexes on a table = unlimited
> >
> > I am not aware of any limit on the number of tables, I should think practical
> > considerations regarding management would cause problems before you hit a
> > real limit.
> >
> > - Richard Huxton
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026