PostgreSQL comes tuned to perform well under a myriad of implementations, but occasionally data analysts or database administrators may notice bottlenecks in the system impacting performance. In this discussion we will evaluate two possible tunes that can be made within the environment that impact how PostgreSQL utilizes the hardware on the server.
Instructions: Visit: https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
Read on the options available for tuning under the categories of: Work_Mem and Effective_Cache_Size and consider how they would possibly be able to improve performance within your environment. Under the impression that users are complaining about poor performance of their queries, answer the following questions (approximately 250 words total):
Which of the two options would you tune?
Why did you make this selection?
What would you update the values to?
If this doesn’t fix performance issues, what would your next step be?