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 1ouq0p-00021W-CE for pgsql-novice@arkaria.postgresql.org; Tue, 15 Nov 2022 07:05:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ouq0o-0005wi-92 for pgsql-novice@arkaria.postgresql.org; Tue, 15 Nov 2022 07:05:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ouq0n-0005tq-SY for pgsql-novice@lists.postgresql.org; Tue, 15 Nov 2022 07:05:38 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ouq0k-0003T5-AS for pgsql-novice@lists.postgresql.org; Tue, 15 Nov 2022 07:05:36 +0000 Received: by mail-ed1-x52d.google.com with SMTP id s12so20545778edd.5 for ; Mon, 14 Nov 2022 23:05:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=yrWxN4yfXV7JO0lsieg6fETugnGysZ57CCbTBRGQfy8=; b=nZKF4bgwwmipHrg5tZS/5EyukbLs/cj9Udfe2zOgszftihaatUZEBeWrJ58/5vo2D6 kSQmZHuok6hJPhYpLbDVHRLT5MktjUfohI04SXkYn6wdG7rmgcSXEDXgupvbPCycp4oO BgGWk1G5RvFxrj5UucGY4rMp1g8Eqx5dOdsPZlA1qNyJr0qJMBDFOa8zntewK2HIuD+l qS5FegBS27rsh99hM86GYeSbWMFoEgywqQ81TlGcH7qtlfuSOWG9qnwxGxNx4Udt4mKy 2JF8eSXmLMZP/wJ8dQOAz5oPdHgxX8RDfZq7hc1BLOt4ACie3DekEwAfveHjIQtH3yBK eKMQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=yrWxN4yfXV7JO0lsieg6fETugnGysZ57CCbTBRGQfy8=; b=1I6fW5ikvN2dMInGwK/wgwBDiuTmeL5ZjYRd2QEqIbVTGOtps8yOGcTK3CcpgJUngt SZSTkOxoFRh1JoKrQPVQ0EfcpkioHkR4B6K3+ikUJw15fP/1d76MYCTx7t+vLzTvbaA5 gbtaB1prflpWYUKFjUQHbLwjZ49CA0X+9M1ZzAVaH/06sJhZQtjJKgHTjoVf3MwF9o8y j9uTvnPRnATPi9VKrIubSfIueqYNz+LogxACYoLRpB1TLLq9RGWOOSJOroYc6x/O9ZYs 80I+22zWZKyKdhXczDEEUcKIj2ObxIz1nge+DnfiMOGyG5I/6Wt5TuqctvNQEy4zLefY Ha8Q== X-Gm-Message-State: ANoB5pl86tHB0wDtIalTGKu5HJwgFc/eR3jB/mvpv94wc0lZFqLd07DE 5sqZxZ1yXm+XTbHqrNkfRpPk/A== X-Google-Smtp-Source: AA0mqf5WgKvFb3p/NzC0Zi46Q25V4DxFSgWe4ZTTR0wLbyiQSgirVPHpSWhjEbAbkfHRcNdnHQjl1Q== X-Received: by 2002:a50:c042:0:b0:460:41e2:b84f with SMTP id u2-20020a50c042000000b0046041e2b84fmr14004820edd.188.1668495932034; Mon, 14 Nov 2022 23:05:32 -0800 (PST) Received: from localhost.localdomain (178-190-182-188.adsl.highway.telekom.at. [178.190.182.188]) by smtp.gmail.com with ESMTPSA id i15-20020a05640200cf00b00463c5c32c6esm5711621edu.89.2022.11.14.23.05.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 14 Nov 2022 23:05:31 -0800 (PST) Message-ID: Subject: Re: hstore or jsonb ? From: Laurenz Albe To: Bzzzz , pgsql-novice@lists.postgresql.org Date: Tue, 15 Nov 2022 08:05:31 +0100 In-Reply-To: <20221114222113.513b7253@msi.defcon1.lan> References: <20221114155057.48406b86@msi.defcon1.lan> <20221114222113.513b7253@msi.defcon1.lan> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2022-11-14 at 22:21 +0100, Bzzzz wrote: > That depends on the query you need to support. > > > > I have no idea what you mean by "fulltext accurate search" in a hstore > > or JSON. > > One kind, that will be something like : > SELECT websearch_to_tsquery('english', 'switching power supply > output tension 5 Vcc 5 A') ; Indexing full text search is simple. If the query is ... WHERE @@ the index is to be CREATE INDEX ON tab USING gin (()); Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com