MIME-Version: 1.0
References: 
 <CAJSrDUqf=A+xmHT_iCSMhr6LReUXoRtGYzuUodBbtnZydAesGA@mail.gmail.com>
In-Reply-To: 
 <CAJSrDUqf=A+xmHT_iCSMhr6LReUXoRtGYzuUodBbtnZydAesGA@mail.gmail.com>
From: Steve Midgley <science@misuse.org>
Date: Thu, 20 Apr 2023 09:25:01 -0700
Message-ID: 
 <CAJexoSLF1r-g8nm+deVt8A=sdOotb1miE6ZXZ+zT+UqxoWnDog@mail.gmail.com>
Subject: Re: PostgreSQL Objects design
To: kunwar singh <krishsingh.111@gmail.com>
Cc: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000280c3105f9c6fcde"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJexoSLF1r-g8nm%2BdeVt8A%3DsdOotb1miE6ZXZ%2BzT%2BUqxoWnDog%40mail.gmail.com>
Precedence: bulk

--000000000000280c3105f9c6fcde
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Apr 20, 2023 at 9:01=E2=80=AFAM kunwar singh <krishsingh.111@gmail.=
com>
wrote:

> Hi Listers,
> I want to learn more about Table/Columns/Indexes  design.
>
>    - How big the columns should be?
>    - How many number of columns should a table have at max?
>    - How many rows a tables should have at max
>    - What are size limitations of different data types
>
>
> Any books, blogs , videos, courses that you recommend I go over?
>
> I have been an Oracle DBA , but only from a support and tuning standpoint=
.
> I have never done this kind of work before, even in Oracle. So interested
> in learning in this area?
>
> Any approach that will speed up my learning?
>

The Postgres docs, IMO, are astonishingly good.
https://www.postgresql.org/docs/ -- Not what I tend to expect from open
source projects, but there's a reason (again IMO) Postgres is the best
database solution ever built. Regarding your specific question here are the
current "hard" limits https://www.postgresql.org/docs/current/limits.html

But recognize that the effective limits on your system are going to be
lower, and based on your available ram, disk, and other resources.

Stackoverflow might be a good place to understand more about these kinds of
limits. I'll say that for my use cases, I've never had to worry about
anything other than applying the right index or reworking my SQL statement
to solve a particular problem in Postgres. So I'd say try to learn about
various index techniques and how to use Postgres' SQL, as the starting
place to learn. I think EnterpriseDB has good resources for those coming
from Oracle as well..

Welcome to the light side!
Steve

--000000000000280c3105f9c6fcde
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Thu, Apr 20, 2023 at 9:01=E2=80=AF=
AM kunwar singh &lt;<a href=3D"mailto:krishsingh.111@gmail.com">krishsingh.=
111@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddi=
ng-left:1ex"><div dir=3D"ltr">Hi Listers,<div><div>I want to learn more abo=
ut Table/Columns/Indexes=C2=A0 design.=C2=A0</div><div><ul><li>How big the =
columns should=C2=A0be?=C2=A0</li><li>How many number of columns should a t=
able have at max?=C2=A0</li><li>How many rows a tables should have=C2=A0at =
max</li><li>What are size limitations of different data types</li></ul><div=
><br></div></div><div>Any books, blogs , videos, courses that you recommend=
 I go=C2=A0over?</div><div><br></div><div>I have been an Oracle DBA , but o=
nly from a support and tuning standpoint. I have never done this kind of wo=
rk=C2=A0before, even=C2=A0in=C2=A0Oracle. So interested in learning in this=
 area?</div><div><br></div><div>Any approach that will speed up my learning=
?=C2=A0</div></div></div></blockquote><div><br></div><div>The Postgres docs=
, IMO, are astonishingly good.=C2=A0<a href=3D"https://www.postgresql.org/d=
ocs/">https://www.postgresql.org/docs/</a> -- Not what I tend to expect fro=
m open source projects, but there&#39;s a reason (again IMO) Postgres is th=
e best database solution ever built. Regarding your specific question here =
are the current &quot;hard&quot; limits <a href=3D"https://www.postgresql.o=
rg/docs/current/limits.html">https://www.postgresql.org/docs/current/limits=
.html</a>=C2=A0</div><div><br></div><div>But recognize that the effective l=
imits on your system are going to be lower, and based on your available ram=
, disk, and other resources.</div><div><br></div><div>Stackoverflow might b=
e a good place to understand more about these kinds of limits. I&#39;ll say=
 that for my use cases, I&#39;ve never had to worry about anything other th=
an applying the right index or reworking my SQL statement to solve a partic=
ular problem in=C2=A0Postgres. So I&#39;d say try to learn about various in=
dex=C2=A0techniques and how to use=C2=A0Postgres&#39; SQL, as the starting =
place to learn. I think EnterpriseDB has good resources for those coming fr=
om Oracle as well..</div><div><br></div><div>Welcome to the light side!</di=
v><div>Steve</div></div></div>

--000000000000280c3105f9c6fcde--