I think it's fairly well known that a normal PostgreSQL database has a starting value of 25% of system memory for its shared_buffers
parameter, but I haven't been able to find anything regarding a proper value for an AWS Aurora instance.
Now I would normally use the community value for this parameter, but the existing system is already using a value of 50% of the available memory, and I'm just not certain that this is a good value.
Of course, for Aurora the shared_buffers
parameter is unique for each database in the system, as opposed to normal PostgreSQL where this is cluster-wide.
Hence, my confusion. Can anyone provide guidance in this manner?