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