On 1/23/17 9:27 AM, Stephen Frost wrote:
If you want my 2c on that, running with BLKSZ <> 8192 is playing with fire, or at least running with scissors.
I've never seen it myself, but I'm under the impression that it's not unheard of for OLAP environments. Given how sensitive PG is to IO latency a larger block size could theoretically mean a big performance improvement in some scenarios.
-- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
