Hi,
If the dynamic shared memory segment type is POSIX then *dynamic shared
memory control segment in your case it is **PostgreSQL.1511679208* is
stored in */dev/shm*
The file you mentioned will be created at the time of PostgreSQL startup
and cleared automatically on successful shutdown.
Compl
, 4:00 PM Ayub M, wrote:
> Thanks, for q2 - if work_mem is a limit before spilling onto disk, is
> there a min amount of memory which gets allocated to each session when it
> starts?
>
> On Mon, Feb 10, 2020 at 3:51 AM Naresh g wrote:
>
>> 1. Yes, by default it is advisa
1. Yes, by default it is advisable to set 25% of RAM to shared buffers
because community version postgres highly depends on OS cache, which means
when you fetch something from disk, it is first copied to OS cache (75%)
then to shared buffers(25%).
Two copies of data will be there in your system R
Dear Team,
We have a production database with two hot standby's at two different
locations.
Let's say A (production) has two standby's (B&C).
Now we are planning to do a BCP activity.
What would be the best plan to do this activity?
As I have two standby's configured, is shutting down one stan
