Re: [GENERAL] shared_buffers formula

emory? Thanks in advance, Alexander Shutyaev 2015-03-03 14:26 GMT+03:00 Andres Freund : > On 2015-03-03 15:06:54 +0400, Alexander Shutyaev wrote: > > Recently we've been having problems with swap on our postgresql server. > It > > has 125GB of RAM. We've decided to calc

[GENERAL] shared_buffers formula

und 252 000 GB which doesn't make any sense. Is there something wrong with the formula? Or should we make our shared_buffers approx. 10 000 times lower? :) Thanks in advance, Alexander Shutyaev [1] http://www.postgresql.org/docs/9.1/static/kernel-resources.html#SHARED-MEMORY-PARAMETERS

[GENERAL] vacuumdb uses a lot of disk

Hi all! We have the following issue. When we use vacuumdb (NOT full) on our postgres database (~320Gb) it takes up ~10Gb of disk space which is never returned. Why is the space not returned? Thanks in advance!

[GENERAL] shared memory settings

Hi all! We have at present the following parameters related to shared memory: *postgres* shared_buffers = 7GB max_connections = 1500 max_locks_per_transaction = 1024 max_prepared_transactions = 0 (not set) *system* SHMALL = 2097152 SHMMAX = 17 670 512 640 SHMMNI = 4096 The amount of RAM is 24