Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ouanl-0007a4-J6 for pgsql-novice@arkaria.postgresql.org; Mon, 14 Nov 2022 14:51:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ouani-00005l-Vb for pgsql-novice@arkaria.postgresql.org; Mon, 14 Nov 2022 14:51:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ouani-00005O-NZ for pgsql-novice@lists.postgresql.org; Mon, 14 Nov 2022 14:51:06 +0000 Received: from mout.gmx.net ([212.227.15.15]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ouand-0007E5-R9 for pgsql-novice@lists.postgresql.org; Mon, 14 Nov 2022 14:51:06 +0000 Received: from mail.defcon1.lan ([93.15.31.113]) by mail.gmx.net (mrgmx004 [212.227.17.184]) with ESMTPSA (Nemesis) id 1MatVh-1pVrUl0peF-00cT5T for ; Mon, 14 Nov 2022 15:51:00 +0100 Date: Mon, 14 Nov 2022 15:50:57 +0100 From: Bzzzz To: pgsql-novice@lists.postgresql.org Subject: hstore or jsonb ? Message-ID: <20221114155057.48406b86@msi.defcon1.lan> Organization: Anyone, anywhere but in banana demokratik republik of france or UERSS. Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:PcVLEzpOmsDu3OUM/kEdTrbBMTmGiSAWXOqY2CT3WPNuUMv68QM EAuCzQmJTXM/cgYgYpqz22pjOdbbOyKpnAttzXigE4MP18iI4u/Ez2FUIUzF5ersOrBDNXT +KzZbSklT0Z621XQONWGnkRE2RA3Q+8EzvzVnSNuLiBBkSFpJPtI2F/jGqi4HjNzHlDtMpO TJ3Y+p/nKKQ2j8Z4Ec/qA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:j/j4CfbO0YE=;HvdePChGnP+SHw+wCYrqCAJ/bR/ uKfvHnhMvB+H577ALDHcxQGik/gV/suwroNh3mv7o2gnqdABuG28fvHc20b4UzxFaFCfpS+H/ drKRv+gD1LLGc98lfTV4DD1qhPXV3ruL4vBR+UPexGT8mFAWK2oh3gMY8PkWvQ2FguId3IREG HIjYArVYCePjFxz0jE5rEI3+1vQYRyzKBi8tlgsMfP0uYJ4c+/M2x7mgGP5gdg9slFUn8qtrV vZnWNlfAWguZPNjf8MzjS1IDxB4ylw9yNrNq/S8gXONZjXqD+lABElBYY9Qk4OXHEhi8paR1m r1jt5ypoAOZhGO9r2yM6t59h1vGSBN0sI5u0MKucxq1IbRObwQ7JzSE/oUcpl+8OFgqQitGaV 87QzOdS0KTHssPrPOL4knNfZxdmlh/lxyqFr83V/xD6OuQGgD0kmj3gGiXv5sxYpuXpIAEI35 zFgCJmcjKMMajg/uS6VsvWlKd7vLhbKwvFt0dZ9XnWG3RpHg1AKVL+EQnzUaXisXaAGofaucq z0TeJx3xL75LzEbsOJYKo/NxgyGu8xmGo4AP6ETMt6EDf4lRJcSjCjsgc4O2nGknT3W4s78w0 GiSUVVZlmPDslSu/oCNu7TdGo1y16Wa9/WpctAjqn6U/avLAGjQ4W1+VD4hiP5QbEkvg6HkmG ZANFAfi0ti5f4FC0+edBN8ZV1HVKvbTjG4lLzDQhu3/WzHszayvO6Llm31TLVMsIZW96WZci1 XIVGt1F3pHm14tIc0+3c43s68v6sRKSYQdf8s2nuF8Wlh+zUEzBXepaTJ6kaMLr8Qt1JweUsr eVxgvfGMjl1EWIoLVnkKUkZWv4eZ3VuU6um/IlE8UkhjGcuCTKdqlLgc4X5SRAmK4qoWuI8ic rXRZYqAtxxfJu6OtLPyM+O2nyqdt69CYFlQ4YL1R9qKxNr/10TJAm0G5822FrTZmPWcsW3UJW 91BzAdMeEq1bS9IzlaVhCErD6AQ= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi folks, I'd like to store specs, as they vary a lot from one item to another, hstore or jsonb look like the best solution. Specs can have 2 levels at most. ie: "color": ["white", "black", "blue"]). The indexation is mandatory for fulltext accurate researches in (almost) natural language. So, as the processing is almost the same (maps I/O in Erlang), which one would be the best for my needs, hstore or jsonb ? Also, from what I read, the both of them can be easily indexed, but which index is the best, GIN or RUM ? And furthermore, which index option (XXX_ops), if any, would be the best for the chosen one ? Jean-Yves