Re: Reducing planning time of large IN queries on primary key / unique columns

anges above is small and we are happy to polish it up and share. Best, Souvik Bhattacherjee (ServiceNow) On Thu, Aug 11, 2022 at 3:04 PM Souvik Bhattacherjee wrote: > (Re-posting with better formatting) > > Hi hackers, > > At ServiceNow, we frequently encounter queries with very

Re: Reducing planning time of large IN queries on primary key / unique columns

51 | 6.738 | 2.90 We see that the planning time of queries on unique columns are identical to that we observed for primary key columns. The resulting patch file for the changes above is small and we are happy to polish it up and share. Best, Souvik Bhattache

Reducing planning time of large IN queries on primary key / unique columns

d for primary key columns. The resulting patch file for the changes above is small and we are happy to polish it up and share. Best, Souvik Bhattacherjee (ServiceNow)

Re: Initializing LWLock Array from Server Code

019 at 1:59 PM Robert Haas wrote: > On Fri, Apr 26, 2019 at 2:58 PM Souvik Bhattacherjee > wrote: > > I have created a shared hash table in partitioned mode inside the > postgres server code. In order to guard the partitions, I'm trying to > initialize an array of LW

Initializing LWLock Array from Server Code

Hi, I have created a shared hash table in partitioned mode inside the postgres server code. In order to guard the partitions, I'm trying to initialize an array of LWLocks. The code that I'm trying to use for that is void RequestNamedLWLockTranche