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

How many tables can be created in one datebase?

From

"Huang@tanpopo-tane.com"

Date:

11 July 2002, 07:26:13

How many tables can be created in one datebase?
How many fields can be created in one table?
thank you

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

From

Richard Huxton

Date:

11 July 2002, 09:30:07

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

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

From

Josh Jore

Date:

11 July 2002, 09:41:57

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
>

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

From

Bruce Momjian

Date:

11 July 2002, 15:36:06

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