Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL memory allocation for 16 GB

------This Is For 16GB RAM BSNL CLOUD----------
shared_buffers = 1GB               (5-25 %)    
effective_cache_size =4GB  default (50-80 %)   ---->>(shared_buffers+page cache) for dedicated server only
work_mem = 128MB                   (0.3-1 %)
maintenance_work_mem = 1GB         (0.5-4 % )
temp_Buffer =  32MB                    ---->>default is better( setting can be changed within individual sessions)
max_wal_senders = 10
wal_keep_segments = 64
wal_buffers = 32MB                     ----->>leave this default 3% of shared buffer is better
random_page_cost = 3.0                 ----->>For fast disks you could reduce that to 3.0
max_connections = 1000


Popular posts from this blog

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

vacuumlo - removing large objects orphans from a database PostgreSQL

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory