Re: Indexes in JSONB

e, Mar 29, 2022 at 7:06 AM Saurav Sarkar > wrote: > >> Hi All, >> >> We use JSONB /NoSQL functionality of PostgreSQL. >> >> One of the column "doc" in our table "Table1" is of type JSONB. >> >> Now the rows in this column "doc

Indexes in JSONB

Hi All, We use JSONB /NoSQL functionality of PostgreSQL. One of the column "doc" in our table "Table1" is of type JSONB. Now the rows in this column "doc" can have different values with different schemas. For e.g values of doc per row will be something like below ROW1 = {"id":"1", "name":"abc

Re: Database Scalability

Hi Ben, Thanks a lot for your reply. So are all the schemas on one DB or are distributed/sharded across multiple DBs ? Best Regards, Saurav On Tue, Nov 30, 2021 at 11:43 PM Ben Chobot wrote: > Saurav Sarkar wrote on 11/29/21 10:13 PM: > > Hi All, > > We have some multi-tenant

Database Scalability

Hi All, We are using Amazon RDS PostgreSQL. We have some multi-tenant solutions which are separating the tenant data in Postgresql mainly in the following manner. 1. Using different schemas 2. Using different tables for different tenants. I was just wondering what would be the best way to scale

Re: Connection queuing by connection pooling libraries

> On Tue, 19 Oct 2021 at 23:09, Vijaykumar Jain < >> vijaykumarjain.git...@gmail.com> wrote: >> >>> >>> On Tue, 19 Oct 2021 at 22:45, Saurav Sarkar >>> wrote: >>> >>>> Hi All, >>>> >>>> >>>> A basic ques

Connection queuing by connection pooling libraries

Hi All, A basic question on handling large number of concurrent requests on DB. I have a cloud service which can get large of requests which will obviously trigger the db operations. Every db will have some max connection limit which can get exhausted on large number of requests. I know db con

Re: Encryption with customer provided key in a multi tenant Postgres JSONB DB

, Saurav On Thu, Nov 12, 2020 at 11:44 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Nov 11, 2020 at 10:49 PM Saurav Sarkar > wrote: > >> We have a multi tenant application where for each tenant we create >> separate tables . So for e.g. if i have

Encryption with customer provided key in a multi tenant Postgres JSONB DB

Hi All, We use Postgres's JSONB structure for NoSQL usage. We have a multi tenant application where for each tenant we create separate tables . So for e.g. if i have 100 tenants then i have 100 tables. Now we want to have encryption for the data in the tables with the tenant provided key. Is it

Re: Case insensitive query on existing data

Thanks a lot Michael . Concurrent index building solves my problem of building index without locking. Best Regards, Saurav On Thu, Aug 13, 2020 at 10:45 PM Michael Lewis wrote: > create index concurrently lower( jsonb->>'name' ), drop old_index > concurrently, ensure that where/on/group by cond

Case insensitive query on existing data

Hi All, We use PostgreSQL JSONB storage. One of the keys in the JSON will be always have a "name" key. We want to perform case insensitive query on the name key. Our application is already live so we have some data and have existing indexes on the name key. I understand that one of the ways is

Usage reporting of Cloud provided PostgreSQL service

Hi All, I would like to know what are the best practices in terms of usage reporting of databases size in cloud setup. One specific question related to the consideration of indexes If i am providing PostgreSQL as a service in a cloud platform , should i consider index size also in the consumptio