Like other databases, PostgreSQL has configuration parameters that can be configured permanently or session predicated. The postgresql.conf
file is utilized to configure most of the configuration parameters. We will only discuss the parameters that can affect the performance. They are as follows:
work_mem
: The disk I/O is the dominant cost factor in queries; if case queries involve a large number of complex sorts, then it can increment the disk access. If the system has lots of recollection, then the database should perform the in-recollection sorting to reduce the disk read. Thework_mem
configuration parameter is utilized to determine when the sorting will be performed in a recollection or the disk sort will be utilized. If we have lots of recollection, then thework_mem
parameter should be set to the optimal value so that every sort can be performed in-recollection. Thework_mem
parameter is per connection for each sort; this makes it authentically...