pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Question about maximum sizes
2+ messages / 2 participants
[nested] [flat]

* Question about maximum sizes
@ 2005-03-03 23:51 Lai, Eric <Eric.Lai3@boeing.com>
  2005-03-07 16:48 ` Re: Question about maximum sizes Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Lai, Eric @ 2005-03-03 23:51 UTC (permalink / raw)
  To: pgsql-admin


I was wondering if you know where I could find specifications on the
PostGresSQL 7.4.3 (the one build one used).  I have information such as:

Maximum size for a database?             unlimited (60GB databases
exist)
 Maximum size for a table?                16 TB
 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?    250-1600 depending on column
types
 Maximum number of indexes on a table?    Unlimited

But I need additional information such as what the maximum size of an
actual index name is and stuff like that.  Do you know where they might
have a more comprehensive guide or documentation that might have this
information? 

__________________________
Eric Lai
Software Engineer
FCS - SOSCOE Data Modeling
Huntington Beach, CA
Cell:    213-453-6878
Desk: 714-896-5687





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Question about maximum sizes
  2005-03-03 23:51 Question about maximum sizes Lai, Eric <Eric.Lai3@boeing.com>
@ 2005-03-07 16:48 ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2005-03-07 16:48 UTC (permalink / raw)
  To: Lai, Eric <Eric.Lai3@boeing.com>; +Cc: pgsql-admin

Lai, Eric wrote:
> 
> I was wondering if you know where I could find specifications on the
> PostGresSQL 7.4.3 (the one build one used).  I have information such as:
> 
> Maximum size for a database?             unlimited (60GB databases
> exist)
>  Maximum size for a table?                16 TB
>  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?    250-1600 depending on column
> types
>  Maximum number of indexes on a table?    Unlimited
> 
> But I need additional information such as what the maximum size of an
> actual index name is and stuff like that.  Do you know where they might
> have a more comprehensive guide or documentation that might have this
> information? 

Yes, run pg_controldata:

	Maximum length of identifiers:        64

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-03-07 16:48 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-03 23:51 Question about maximum sizes Lai, Eric <Eric.Lai3@boeing.com>
2005-03-07 16:48 ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox