MIME-Version: 1.0
From: kunwar singh <krishsingh.111@gmail.com>
Date: Thu, 20 Apr 2023 12:01:02 -0400
Message-ID: 
 <CAJSrDUqf=A+xmHT_iCSMhr6LReUXoRtGYzuUodBbtnZydAesGA@mail.gmail.com>
Subject: PostgreSQL Objects design
To: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000056984b05f9c6a689"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJSrDUqf%3DA%2BxmHT_iCSMhr6LReUXoRtGYzuUodBbtnZydAesGA%40mail.gmail.com>
Precedence: bulk

--00000000000056984b05f9c6a689
Content-Type: text/plain; charset="UTF-8"

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?

-- 
Cheers,
Kunwar

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

<div dir=3D"ltr">Hi Listers,<div><div>I want to learn more about Table/Colu=
mns/Indexes=C2=A0 design.=C2=A0</div><div><ul><li>How big the columns shoul=
d=C2=A0be?=C2=A0</li><li>How many number of columns should a table have at =
max?=C2=A0</li><li>How many rows a tables should have=C2=A0at max</li><li>W=
hat 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=A0ov=
er?</div><div><br></div><div>I have been an Oracle DBA , but only from a su=
pport and tuning standpoint. I have never done this kind of work=C2=A0befor=
e, 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><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div di=
r=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature">Chee=
rs,<br>Kunwar</div></div></div>

--00000000000056984b05f9c6a689--