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 ) id 1tPmr6-00FIAp-Kc for pgsql-general@arkaria.postgresql.org; Mon, 23 Dec 2024 18:08:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tPmr5-00DtpN-LD for pgsql-general@arkaria.postgresql.org; Mon, 23 Dec 2024 18:08:35 +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 ) id 1tPmr4-00DtnG-J1 for pgsql-general@lists.postgresql.org; Mon, 23 Dec 2024 18:08:35 +0000 Received: from fout-b7-smtp.messagingengine.com ([202.12.124.150]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tPmr0-001G91-2B for pgsql-general@postgresql.org; Mon, 23 Dec 2024 18:08:33 +0000 Received: from phl-compute-12.internal (phl-compute-12.phl.internal [10.202.2.52]) by mailfout.stl.internal (Postfix) with ESMTP id 929B91140193; Mon, 23 Dec 2024 13:08:27 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-12.internal (MEProxy); Mon, 23 Dec 2024 13:08:27 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1734977307; x=1735063707; bh=KJCaTlgWJdAuIT/yAGVpi4UbaRb2pfJBbDQohvn+n3M=; b= W6Y5dT4wzuTqOz90bAIQ/GM6SGJ1NJXy5RbR2tI3j2GfHJMhPyBUlE08sww3ktbm 8dJhlTVHWGaN072qwykdbjkiOhJFuu6nIcCiqazR4jKuwW55f6bkgcnWAEy2dacv N+zh5kwr2wbHsu3fPlOQbijDgkE1I1KdmmYDjDvSG5YAp9nLSBHjxuAG2tIs9CR0 3+LAru4UEyxH8bLOvKyKPqi3CruUeKptd0JrsJgCUFPaukrQGanGyewoj+YMsgad fV1Qmx/RfPNQA1irx3aQQ+Y7jFWiTUXLpY4tFiL0hr5eCdBiDdbUT1NNn+ohPkAd Fq2hBdFck1rfDWua3753rA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1734977307; x= 1735063707; bh=KJCaTlgWJdAuIT/yAGVpi4UbaRb2pfJBbDQohvn+n3M=; b=G kW2TSbtE53sdqA2eFbu40b/eDnHih4h9nYMUX511N1CBhQiXpy6LaZOBEhUcTqfL IkRTe1lPNi4IGOKRV7aDd3XmbiRH6ESBwfp2+K+0gic5w/ocReUsahRXiASjl8lo BUJG+JQ1zOYUockumvu5kyQahnDxCAWNb8E4i6IFbbENZ0zUvGoQmBQZepbVxvy5 l4RQ+i5FtuLv3+yF5KHBhKIgqXQpHoImShxVsll5BChnEbrOPNY65QgqHGjilCvX t9a5e+LWrfbmpgq9nsPVRYzYKkvC1z7aljX1MRy2tLD4/F0d5B7MMoayCD7VKPvN LYjeN5qeKa2VUctxixUwA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrudduvddggeehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucenucfjughrpefkffggfg fuvfevfhfhjggtgfesthejredttddvjeenucfhrhhomheptegurhhirghnucfmlhgrvhgv rhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrg htthgvrhhnpefhveeihfevlefffedthedukeevfefhfedtgeeifeevteffgfefhedtffet udettdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe grughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpdhnsggprhgtphhtthho peefpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegrghduheeijeekvdejsehgmh grihhlrdgtohhmpdhrtghpthhtoheprhhonhhljhhohhhnshhonhhjrhesghhmrghilhdr tghomhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehpohhsthhgrhgvshhqlh drohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 23 Dec 2024 13:08:26 -0500 (EST) Message-ID: <1823b892-facf-4515-a44d-f9a0aa9025da@aklaver.com> Date: Mon, 23 Dec 2024 10:08:25 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Need help in database design To: Divyansh Gupta JNsThMAudy , Ron Johnson Cc: pgsql-general References: <06e1f1ee-74b2-43a2-9a63-da20ae455ae2@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12/23/24 09:49, Divyansh Gupta JNsThMAudy wrote: > I have one confusion with this design if I opt to create 50 columns I > need to create 50 index which will work with userid index in Bitmap on > the other hand if I create a JSONB column I need to create a single index ? > There still is the part where you plan to partition this data on some as not yet fully specified hash. -- Adrian Klaver adrian.klaver@aklaver.com