Some of you may have had annoying problems in the past with autofreeze or
autovacuum running at unexpected moments and dropping the performance of your
server randomly.
On our SSD-RAID10 based system we found a 20GB table finished it's vacuum
freeze in about 100 seconds. There were no
Entire database. People have talked about using SSDs for data/indices and
spinning disks for WAL. However I find having everything on the same disks is
good for 3 reasons.
1. The SSD is simply vastly faster than the disks. That means if huge amount of
WAL is being written out (e.g. tons of
Did you put your entire database on SSD or just the WAL/indexes?
On 28 July 2015 at 23:39, Graeme B. Bell graeme.b...@nibio.no wrote:
Some of you may have had annoying problems in the past with autofreeze or
autovacuum running at unexpected moments and dropping the performance of
your server