Re: Allocating shared memory in Postgres

2019-07-03 Thread Souvik Bhattacherjee
For starters, what happens if two backends do this concurrently? > I'm assuming here that a single backend process handles all queries from a given client. In case of parallel queries, the master process will be responsible for allocating the shared memory and not the workers. Please let me know i

Re: Allocating shared memory in Postgres

2019-07-03 Thread Tom Lane
Souvik Bhattacherjee writes: > I need to allocate shared memory in Postgres 11.0 outside the > initialization phase. In order to achieve this I have done the following: > - during a particular query, where I need to allocate shared memory (which > is a function of the sizes of the tables in the qu

Allocating shared memory in Postgres

2019-07-03 Thread Souvik Bhattacherjee
Hi, I need to allocate shared memory in Postgres 11.0 outside the initialization phase. In order to achieve this I have done the following: - increased the amount of shared memory by increasing the value of size in CreateSharedMemoryAndSemaphores (int port) in ipci.c. I have made sure that the am