Re: Need help in database design

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Divyansh Gupta JNsThMAudy <ag1567827(at)gmail(dot)com>
Cc: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Need help in database design
Date: 2024-12-23 21:22:51
Message-ID: CAKAnmmJ=MQf7faa2KqmVrgDLTg9XhSkTyK-W-itFJAC9i=+31g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Olleg Samoylov 2024-12-24 05:46:09 "trailing junk after numeric literal at or near ""512<d0>"""
Previous Message David G. Johnston 2024-12-23 21:03:12 Re: Need help in database design