Search Postgresql Archives

Re: Need help in database design

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Need help in database design
From: Greg Sabino Mullane <htamfids@xxxxxxxxx>
Date: Mon, 23 Dec 2024 16:22:51 -0500
Cc: Ron Johnson <ronljohnsonjr@xxxxxxxxx>, pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAHesJ5++Ca0W9DSWA-XtfHohuD8a15GuaPk_DEPU3ggeq9WHWw@mail.gmail.com>
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>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Need help in database design
  - From: Divyansh Gupta JNsThMAudy
- Re: Need help in database design
  - From: Adrian Klaver
- Re: Need help in database design
  - From: Divyansh Gupta JNsThMAudy
- Re: Need help in database design
  - From: Divyansh Gupta JNsThMAudy
- Re: Need help in database design
  - From: Adrian Klaver
- Re: Need help in database design
  - From: Divyansh Gupta JNsThMAudy
- Re: Need help in database design
  - From: David G. Johnston
- Re: Need help in database design
  - From: Divyansh Gupta JNsThMAudy
- Re: Need help in database design
  - From: Divyansh Gupta JNsThMAudy
- Re: Need help in database design
  - From: Ron Johnson
- Re: Need help in database design
  - From: Divyansh Gupta JNsThMAudy
- Re: Need help in database design
  - From: Ron Johnson
- Re: Need help in database design
  - From: Divyansh Gupta JNsThMAudy
- Re: Need help in database design
  - From: Divyansh Gupta JNsThMAudy
- Re: Need help in database design
  - From: Ron Johnson
- Re: Need help in database design
  - From: Divyansh Gupta JNsThMAudy
- Re: Need help in database design
  - From: Divyansh Gupta JNsThMAudy
- Re: Need help in database design
  - From: Ron Johnson
- Re: Need help in database design
  - From: Divyansh Gupta JNsThMAudy

Prev by Date: Re: Need help in database design
Next by Date: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org
Previous by thread: Re: Need help in database design
Next by thread: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]