Re: Large scale reliable software system

2023-06-27 Thread Saurabh Agrawal
> Correct. It’s a tragically wrong piece of folk wisdom that’s pretty general across web development communities. So, what's your advice, and is there some book / resource to get upto speed? Thanks! On Tue, Jun 27, 2023 at 10:38 AM Guyren Howe wrote: > Correct. It’s a tragically wrong piece

Re: Regex for Word space Word space Word ....

2021-11-23 Thread Saurabh Agrawal
> > > I was trying to make it to match words starting capital letter only. > Does this work? https://regex101.com/r/nf4HCN/1 > > Regards, > David > > On Tue, 23 Nov 2021 at 10:59, chlor wrote: > >> On Tue, Nov 23, 2021 at 11:51 AM Shaozhong SHI >> wrote: >> >>> I tried nested regex

Re: Need help on query optimization

2021-03-22 Thread Saurabh Agrawal
> > > Here B is a ltree column, E is a jsonb column. > It may also help to mention the indexes and their types. eg. Does column B have a GiST index? > > EXPLAIN ANALYZE SELECT * FROM A > > where ( B <@ 'INDIA' ) AND C = 'D' > > AND CAST ( E->'F'->'G'->>'H' AS DATE ) >= '2021-02-01' > > AND

Re: table is hanging

2019-05-31 Thread Saurabh Agrawal
Which query are you trying to run? On Fri, May 31, 2019, 16:45 Sonam Sharma wrote: > I only fetched 2 rows and it's responding > > On Fri, May 31, 2019, 4:39 PM Nicklas Avén > wrote: > >> To find out if there is some locking problem or just takes time for the >> client to handle the data, ask

Re: We find few queries running three times simultaneously with same parameters on postgres db

2018-06-26 Thread Saurabh Agrawal
> > > Am 26.06.2018 um 12:19 schrieb amandeep singh: > >> We have been observing our postgres database from past few days,We found >> few queries running three times simultaneously with same parameters.I would >> like to back track how a query is running multiple times. > > Can you check the