Re: postgres limitation - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: postgres limitation
Date
Msg-id 200101281544.KAA01275@candle.pha.pa.us
Whole thread Raw
In response to Re: postgres limitation  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-admin
> > > Maximum size for a table?
> > >
> > > 2G blocks, hence 16 to 64 terabytes depending on the BLCKSZ
> > > configuration constant.  (If someone were to run around and make sure
> > > all the block-number arithmetic is unsigned, we could claim 4G blocks,
> > > but I think it's not all unsigned now...)

Added to TODO:

* Make sure all block numbers are unsigned to increase maximum table size

--
  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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: postgres limitation
Next
From: Bruce Momjian
Date:
Subject: Re: postgres limitation