Re:BRIN Indexes in Postgres 9.5
by pgaddict on Saturday September 17, 2016 @02:53PM
(#12521835)
It's quite difficult (or impossible) to get a single "right" value, as it depends both on the workload and hardware (say, whether you have SSDs attached directly or through a RAID controller).
I did some testing a while ago and didn't see much gain past 30 on 4 SSD disks. Should do another round of testing. Thank you for sharing.