public inbox for [email protected]  

help / color / mirror / Atom feed

From: kunwar singh <[email protected]>
To: [email protected]
Subject: PostgreSQL Objects design
Date: Thu, 20 Apr 2023 12:01:02 -0400
Message-ID: <CAJSrDUqf=A+xmHT_iCSMhr6LReUXoRtGYzuUodBbtnZydAesGA@mail.gmail.com> (raw)

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

view thread (3+ 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: PostgreSQL Objects design
  In-Reply-To: <CAJSrDUqf=A+xmHT_iCSMhr6LReUXoRtGYzuUodBbtnZydAesGA@mail.gmail.com>

* 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