Re: postgresql database limit check - Mailing list pgsql-bugs

From John R Pierce
Subject Re: postgresql database limit check
Date
Msg-id 561DD94B.2020004@hogranch.com
Whole thread Raw
In response to postgresql database limit check  (許耀彰 <kpm906@gmail.com>)
List pgsql-bugs
On 10/13/2015 8:01 PM, 許耀彰 wrote:
> Because we can install postgresql in ubuntu or centos server, we want
> to make sure the postgresql is there any limit for it, Such as
> database size and table size .

the only absolute limitation I know of relates to how many columns can
be stored in a single row, its around 1000, due to the 8K byte
blocksize... Note, normally anything more than 100 or so columns is
often an indication of poor schema design.

--
john r pierce, recycling bits in santa cruz

pgsql-bugs by date:

Previous
From: Matthew Bellew
Date:
Subject: Re: BUG #13614: Optimizer choosing
Next
From: Haribabu Kommi
Date:
Subject: Re: postgresql database limit check