Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tPptl-00FhO6-ND
	for pgsql-general@arkaria.postgresql.org; Mon, 23 Dec 2024 21:23:34 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tPptk-00GFNf-Ur
	for pgsql-general@arkaria.postgresql.org; Mon, 23 Dec 2024 21:23:32 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <htamfids@gmail.com>)
	id 1tPptk-00GFNX-JG
	for pgsql-general@lists.postgresql.org; Mon, 23 Dec 2024 21:23:32 +0000
Received: from mail-io1-xd34.google.com ([2607:f8b0:4864:20::d34])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <htamfids@gmail.com>)
	id 1tPpth-001Hjd-Nk
	for pgsql-general@postgresql.org; Mon, 23 Dec 2024 21:23:31 +0000
Received: by mail-io1-xd34.google.com with SMTP id ca18e2360f4ac-844e161a957so362873239f.0
        for <pgsql-general@postgresql.org>; Mon, 23 Dec 2024 13:23:29 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1734989008; x=1735593808; darn=postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=M4oAfenE3rTf78ZmbUSCNL3sRHU0SCAor9LRH+OZ8sM=;
        b=ERqQdE3sOTyG+rSxyobq2Z4/UZIw8+t6s0FKVvvi6b7t/ch9oxGLlugOKLketkTRQP
         6fTM5gMu1WEDHYcOLp6cm8eO1Z5lefdJavMp/hHrf15lM888X3dCzF6T0+ajPotLlRPh
         1nW8e62Xmlds0Tr/pR4JLUjW4Yah+4v+FIRVrmiBdvD87BG0yaP0blvUO0SDzT5ian6u
         bzYmrWsUJSXJ8nITwe/PtMBy5yhMLfhagAg3KpYTsYU9QPaAnk7ArfQ/sKYysOpcBfTm
         1It4moc/WVjKsfQFBxoxIcS/zCLELwKVLSz3ASYnQv/2xSJzttlFaSE1tXNgT+vuorqE
         lyVw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1734989008; x=1735593808;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=M4oAfenE3rTf78ZmbUSCNL3sRHU0SCAor9LRH+OZ8sM=;
        b=eojEZRwqtEyc88U4xM2FdPKQTnXxc6rxEs66KskLHQEsjn8tsrUMkO5Q6gRXYijoGf
         TmzS5CSJjcmq0C6avV+GrYXooUtJoF+iHZXLDTBdGlvUs/ZOEJMgojRXmTN3IKiuYSv3
         NGcb9N6Dxk4REsOtFEdZKkEgulQwFKwG+lwFh1Esxpyc28ts6kskQ3Apv130CV/QImii
         rr6RQntOrPUivx6ey1dfa/gfU5Xq1ADs9xVzPbnSDSdCytYylBdnGMB+J1ZXu8zqocxZ
         eoP5SHbb77zav0w3z/hbmddMHwVIemKid2hvI7N7Z4WqKA8QKAhkb4/zJt5uP4uiFJuX
         lP4Q==
X-Forwarded-Encrypted: i=1; AJvYcCXMoICRsOBLhh5JkgsV4hio9grq+8Cc7ecKegDKLU2ZuXozZffek8LyxGk6fSlr/8ou2zcAemy83FwvwiKv@postgresql.org
X-Gm-Message-State: AOJu0YzIFGcU80mA8nWIVLOTzklMdAvqSMXh9bmsLRVRkwUD4Mj9h0mS
	M+WGePTLLNqgavMdSSE3Og0olq3PuM1SvEMLL313Nyqj9XmKC7Ia9jqcIIQjK3FMJBTV1sP/b6d
	JalDiTvH5EREP422r1I0tfq0DwgI=
X-Gm-Gg: ASbGncuxcQEMZ2pWRdewBDX3CIkKskY8ZgvOiztGTl0o31WOojnU7XJE/4AGuKRoa/D
	jflNWewmqc8ye32g2xNY3PEpRbyoYyDEdXs23k7j27jyVFqulVFXh
X-Google-Smtp-Source: AGHT+IGS6cM5pROHY1xfyCo3FY17RKf5mR8yLTof1NfkCYx7vgQj37PHAygGyKkBiOF9hikWN2vYQyQYjVoi9nbFTEA=
X-Received: by 2002:a05:6e02:3b85:b0:3a7:8c3f:edce with SMTP id
 e9e14a558f8ab-3c2d14d21a9mr156615885ab.3.1734989008195; Mon, 23 Dec 2024
 13:23:28 -0800 (PST)
MIME-Version: 1.0
References: <CAHesJ5LES3aTDf=xp7NOwrADQ_HWC-Spsv7yLu9ZY+zxzZO53A@mail.gmail.com>
 <b450927c-49da-46e5-ad74-bf38ceff166b@aklaver.com> <CAHesJ5+ASNoSNMiC5Ms0Ts=gw7v2_UeBpUT=phujO4yE_XCbEw@mail.gmail.com>
 <CAHesJ5JbkCBZ2f_AvUr8+KWnGPAsobu4zyfnWm8bEeb7X9oqDQ@mail.gmail.com>
 <06e1f1ee-74b2-43a2-9a63-da20ae455ae2@aklaver.com> <CAHesJ5JLzhHiGSBSkJZ7x7rGgHeeByP=wWk1D5GG=x8cJ5YY6Q@mail.gmail.com>
 <CAKFQuwYdpzwcbSdQ8TvZ-nVjPeHVVz+5=bWofCbUK+p_o=axrQ@mail.gmail.com>
 <CAHesJ5+yTenkAxOT8H33Cfe=1b2kSyXGqxFYfYz5fgYAVVvFmw@mail.gmail.com>
 <CAHesJ5KaJ8p7QhB9UUoFEbA87cU7ke4GBMkKR3q2FJPVv9GXyw@mail.gmail.com>
 <CANzqJaB_s8eXCZJvYO9CLvgJNqrshD=G5GgECi1M9=vk-JHjdQ@mail.gmail.com>
 <CAHesJ5LgLi9-uGCk3J9TUkuyttysz3fzTaP+o57EjcBtwDYKZA@mail.gmail.com>
 <CANzqJaD-MwXzvg97q0iLvAdkf=DnUMOq0Ex2_eNU7sTxEL7bfA@mail.gmail.com>
 <CAHesJ5KtKm9fjhMdR1+cC-M5jW98Sz6sWKbt0mN6SJcfkq9eig@mail.gmail.com>
 <CAHesJ5Kne6MZakdhcQ9Zc-5KhBvhgUt+zUXuX5v6z+zwTY6gLQ@mail.gmail.com>
 <CANzqJaDb901c=fbicfuzXu1kvf1OR+6rtRZvtHOPyGaOD2E99Q@mail.gmail.com>
 <CAHesJ5LbFjqN0NndYUHKsXX_JssgwM-VPPaYoi28kZvsciFifQ@mail.gmail.com>
 <CAHesJ5Kn4bm6DmEVtEmHc1itXovdqNo8iE4kiDunH3gYK5jF4A@mail.gmail.com>
 <CANzqJaBhAissakbxvn6hUBenHBkHzjODGyw-Yg3z_EcsfYhKmg@mail.gmail.com> <CAHesJ5++Ca0W9DSWA-XtfHohuD8a15GuaPk_DEPU3ggeq9WHWw@mail.gmail.com>
In-Reply-To: <CAHesJ5++Ca0W9DSWA-XtfHohuD8a15GuaPk_DEPU3ggeq9WHWw@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Mon, 23 Dec 2024 16:22:51 -0500
Message-ID: <CAKAnmmJ=MQf7faa2KqmVrgDLTg9XhSkTyK-W-itFJAC9i=+31g@mail.gmail.com>
Subject: Re: Need help in database design
To: Divyansh Gupta JNsThMAudy <ag1567827@gmail.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>, pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000085de050629f69bd8"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmJ%3DMQf7faa2KqmVrgDLTg9XhSkTyK-W-itFJAC9i%3D%2B31g%40mail.gmail.com>
Precedence: bulk

--00000000000085de050629f69bd8
Content-Type: text/plain; charset="UTF-8"

You might also look into using a bitmap, for some or all of those fields.
It depends on how many distinct values each can have, of course, and also
on how exactly they are accessed, but bitmaps can save you quite a bit of
space.

Cheers,
Greg

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

<div dir=3D"ltr">You might also look into using a bitmap, for some or all o=
f those fields. It depends on how many distinct values each can have, of co=
urse, and also on how exactly they are=C2=A0accessed, but bitmaps can save =
you quite a bit of space.<div><br></div><div>Cheers,</div><div>Greg</div><d=
iv><br></div></div>

--00000000000085de050629f69bd8--