Обсуждение: How many tables can be created in one datebase?
How many tables can be created in one datebase? How many fields can be created in one table? thank you
On Thursday 11 Jul 2002 9:24 am, huang@tanpopo-tane.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
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@tanpopo-tane.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 >
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@tanpopo-tane.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@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026