Re: Postgresql, PSN hack and table limits - Mailing list pgsql-general

From Jasen Betts
Subject Re: Postgresql, PSN hack and table limits
Date
Msg-id ipjig5$a16$1@reversiblemaps.ath.cx
Whole thread Raw
In response to Postgresql, PSN hack and table limits  (Mark Morgan Lloyd <markMLl.pgsql-general@telemetry.co.uk>)
Responses Re: Postgresql, PSN hack and table limits  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 2011-05-01, Mark Morgan Lloyd <markMLl.pgsql-general@telemetry.co.uk> wrote:
> Somebody is making a very specific claim that Postgres can support a
> limited number of rows:
>
> "INPS (a data forensics team) said that there is 7 main Databases all
> hosted at different data centers but linked over a type of 'cloud' Each
> database uses PostGRESSQL which would mean the most amount of data each
> database could hold with no stability issues is aproximitely equal to
> that of 10,348,439 Rows" http://pastebin.com/MtX1MDdh
>
> Does anybody have any idea where they've got hold of this figure?

the figure is within 1% of the maximun size for data stored in text
(or bytea) column.  It doesn't seem close to any other PG limit that
I know of.






--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Basil Bourque
Date:
Subject: Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)
Next
From: Jasen Betts
Date:
Subject: Re: Short-circuit boolean evaluation