Db settings
Queries that have the highest frequency of execution
Showing 12 entries
Name
Setting Unit Short desc
work_mem 4096 kB Sets the maximum memory to be used for query workspaces.
wal_buffers 512 8kB Sets the number of disk-page buffers in shared memory for WAL.
shared_buffers 16384 8kB Sets the number of shared memory buffers used by the server.
random_page_cost 4 Sets the planner's estimate of the cost of a nonsequentially fetched disk page.
min_wal_size 80 MB Sets the minimum size to shrink the WAL to.
max_wal_size 1024 MB Sets the WAL size that triggers a checkpoint.
max_connections 100 Sets the maximum number of concurrent connections.
maintenance_work_mem 65536 kB Sets the maximum memory to be used for maintenance operations.
effective_io_concurrency 1 Number of simultaneous requests that can be handled efficiently by the disk subsystem.
effective_cache_size 524288 8kB Sets the planner's assumption about the total size of the data caches.
default_statistics_target 100 Sets the default statistics target.
checkpoint_completion_target 0.5 Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.