Re: Postgresql, PSN hack and table limits

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql, PSN hack and table limits
Date: 2011-05-01 12:08:37
Message-ID: ipjig5$a16$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2011-05-01, Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2011-05-01 12:27:43 Re: Short-circuit boolean evaluation
Previous Message Basil Bourque 2011-05-01 08:58:53 Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)