public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jonathan S. Katz <[email protected]>
To: Steve Atkins <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Is this still accurate?
Date: Fri, 5 Jan 2018 14:09:21 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <4fe11dc1b660433594624b280b8ad832@SC58MEXGP036.CORP.CHARTERCOM.com>
<3d7cd4673a80438798ad20b83411e3ca@SC58MEXGP001.CORP.CHARTERCOM.com>
<1646547df04f4555a548ad7815208d5f@SC58MEXGP036.CORP.CHARTERCOM.com>
<[email protected]>
<68e5e2554e2240c6a22bd384fa7c9659@SC58MEXGP036.CORP.CHARTERCOM.com>
<[email protected]>
<[email protected]>
--Apple-Mail=_C1457EF3-D26E-4E06-BFB7-C6F5CD635A88
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
charset=utf-8
<html><head></head><body dir=3D"auto" style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div =
class=3D"ApplePlainTextBody">Hi,<br><br><blockquote type=3D"cite">On Jan =
5, 2018, at 1:33 PM, Steve Atkins <[email protected]> =
wrote:<br><br><br><blockquote type=3D"cite">On Jan 5, 2018, at 10:00 AM, =
Stephen Frost <[email protected]> =
wrote:<br><br>Greetings,<br><br>* Moser, Glen G ([email protected]) =
wrote:<br><blockquote type=3D"cite">That's really the gist of the =
concern from a team member of mine. Not that the 4TB number is =
wrong but that it could be misleading to assume that 4TB is some sort of =
upper bound.<br><br>That's how this concern was relayed to me and I am =
just following up.<br></blockquote><br>Well, saying 'in excess of' is =
pretty clear, but I don't think the<br>sentence is really adding much =
either, so perhaps we should just remove<br>it.<br></blockquote><br>It's =
been useful a few times to reassure people that we can handle =
"large"<br>databases operationally, rather than just having large =
theoretical limits.<br><br>Updating it would be great, or wrapping a =
little more verbiage around the<br>4TB number, but a mild -1 on removing =
it altogether.<br></blockquote><br>Here is a proposed patch that updates =
the wording:<br><br><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"> </span>"There are active PostgreSQL =
instances in production environments that manage many terabytes of data, =
as well as clusters managing petabytes.=E2=80=9D<br><br>The idea is that =
it gives a sense of scope for how big instances/clusters can run without =
fixing people on a number. People can draw their own conclusions =
from the hard limits further down the =
page.<br><br>Best,<br><br>Jonathan<br><br><br><br><object =
name=3D"0001-Modify-sentence-on-production-PostgreSQL-instances-o.patch" =
data=3D"cid:4131FBB4-D303-4436-B975-DFE4E1E42DBF@home" =
type=3D"application/x-apple-msg-attachment" apple-inline=3D"no" =
id=3D"55FA3E44-8AEE-4242-AF11-69FFDA2950C7" height=3D"102" width=3D"150" =
apple-width=3D"yes" apple-height=3D"yes"></object></div></body></html>=
--Apple-Mail=_C1457EF3-D26E-4E06-BFB7-C6F5CD635A88
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename=0001-Modify-sentence-on-production-PostgreSQL-instances-o.patch
Content-Type: application/octet-stream;
x-unix-mode=0644;
name="0001-Modify-sentence-on-production-PostgreSQL-instances-o.patch"
Content-Id: <4131FBB4-D303-4436-B975-DFE4E1E42DBF@home>
=46rom=205d6e902dd9f11973851cffa75abf3917a4d1e36a=20Mon=20Sep=2017=20=
00:00:00=202001=0AFrom:=20"Jonathan=20S.=20Katz"=20=
<[email protected]>=0ADate:=20Fri,=205=20Jan=202018=20=
13:59:00=20-0500=0ASubject:=20[PATCH]=20Modify=20sentence=20on=20=
production=20PostgreSQL=20instances=20on=20about=0A=20page.=0A=0A---=0A=20=
templates/pages/about.html=20|=204=20++--=0A=201=20file=20changed,=202=20=
insertions(+),=202=20deletions(-)=0A=0Adiff=20--git=20=
a/templates/pages/about.html=20b/templates/pages/about.html=0Aindex=20=
9f6ef42..5af7222=20100644=0A---=20a/templates/pages/about.html=0A+++=20=
b/templates/pages/about.html=0A@@=20-22,8=20+22,8=20@@=20for=20fault=20=
tolerance.=20It=20supports=20international=20character=20sets,=20=
multibyte=0A=20character=20encodings,=20Unicode,=20and=20it=20is=20=
locale-aware=20for=20sorting,=0A=20case-sensitivity,=20and=20formatting.=20=
It=20is=20highly=20scalable=20both=20in=20the=20sheer=20quantity=0A=20of=20=
data=20it=20can=20manage=20and=20in=20the=20number=20of=20concurrent=20=
users=20it=20can=0A-accommodate.=20There=20are=20active=20PostgreSQL=20=
systems=20in=20production=20environments=20that=0A-manage=20in=20excess=20=
of=204=20terabytes=20of=20data.=20Some=20general=20PostgreSQL=20limits=20=
are=0A+accommodate.=20There=20are=20active=20PostgreSQL=20instances=20in=20=
production=20environments=20that=0A+manage=20many=20terabytes=20of=20=
data,=20as=20well=20as=20clusters=20managing=20petabytes.=20Some=20=
general=20PostgreSQL=20limits=20are=0A=20included=20in=20the=20table=20=
below.=20</p><div=20class=3D"informaltable"><a=20=
name=3D"table1"></a><table=20border=3D"0"><colgroup><col=20/><col=20=
/></colgroup><thead><tr><th><span=20=
class=3D"bold"><b>Limit</b></span></th><th><span=20=
class=3D"bold"><b>Value</b></span></th></tr></thead><tbody><tr><td>Maximum=
=20Database=20Size</td><td>Unlimited</td></tr><tr><td>Maximum=20Table=20=
Size</td><td>32=20TB</td></tr><tr><td>Maximum=20Row=20Size</td><td>1.6=20=
TB</td></tr><tr><td>Maximum=20Field=20Size</td><td>1=20=
GB</td></tr><tr><td>Maximum=20Rows=20per=20=
Table</td><td>Unlimited</td></tr><tr><td>Maximum=20Columns=20per=20=
Table</td><td>250=20-=201600=20depending=20on=20column=20=
types</td></tr><tr><td>Maximum=20Indexes=20per=20=
Table</td><td>Unlimited</td></tr></tbody></table></div>=0A=20=
<p>PostgreSQL=20has=20won=20<a=20href=3D"/about/quotesarchive">praise=20=
from=20its=20users</a>=20and=20<a=20href=3D"/about/awards">industry=20=
recognition</a>,=20including=20the=20Linux=20New=20Media=20Award=20for=20=
Best=20Database=20System=20and=20five=20time=20winner=20of=20the=20The=20=
Linux=20Journal=20Editors'=20Choice=20Award=20for=20best=20DBMS.=0A=20=0A=
--=20=0A2.14.3=20(Apple=20Git-98)=0A=0A=
--Apple-Mail=_C1457EF3-D26E-4E06-BFB7-C6F5CD635A88--
Attachments:
[application/octet-stream] 0001-Modify-sentence-on-production-PostgreSQL-instances-o.patch (2.1K, 2-0001-Modify-sentence-on-production-PostgreSQL-instances-o.patch)
download | inline diff:
From 5d6e902dd9f11973851cffa75abf3917a4d1e36a Mon Sep 17 00:00:00 2001
From: "Jonathan S. Katz" <[email protected]>
Date: Fri, 5 Jan 2018 13:59:00 -0500
Subject: [PATCH] Modify sentence on production PostgreSQL instances on about
page.
---
templates/pages/about.html | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/templates/pages/about.html b/templates/pages/about.html
index 9f6ef42..5af7222 100644
--- a/templates/pages/about.html
+++ b/templates/pages/about.html
@@ -22,8 +22,8 @@ for fault tolerance. It supports international character sets, multibyte
character encodings, Unicode, and it is locale-aware for sorting,
case-sensitivity, and formatting. It is highly scalable both in the sheer quantity
of data it can manage and in the number of concurrent users it can
-accommodate. There are active PostgreSQL systems in production environments that
-manage in excess of 4 terabytes of data. Some general PostgreSQL limits are
+accommodate. There are active PostgreSQL instances in production environments that
+manage many terabytes of data, as well as clusters managing petabytes. Some general PostgreSQL limits are
included in the table below. </p><div class="informaltable"><a name="table1"></a><table border="0"><colgroup><col /><col /></colgroup><thead><tr><th><span class="bold"><b>Limit</b></span></th><th><span class="bold"><b>Value</b></span></th></tr></thead><tbody><tr><td>Maximum Database Size</td><td>Unlimited</td></tr><tr><td>Maximum Table Size</td><td>32 TB</td></tr><tr><td>Maximum Row Size</td><td>1.6 TB</td></tr><tr><td>Maximum Field Size</td><td>1 GB</td></tr><tr><td>Maximum Rows per Table</td><td>Unlimited</td></tr><tr><td>Maximum Columns per Table</td><td>250 - 1600 depending on column types</td></tr><tr><td>Maximum Indexes per Table</td><td>Unlimited</td></tr></tbody></table></div>
<p>PostgreSQL has won <a href="/about/quotesarchive">praise from its users</a> and <a href="/about/awards">industry recognition</a>, including the Linux New Media Award for Best Database System and five time winner of the The Linux Journal Editors' Choice Award for best DBMS.
--
2.14.3 (Apple Git-98)
view thread (11+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Is this still accurate?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox