autovacuum is not turned off (it’s on by default)
wal_sync_method = fsync wal_buffers = 128 checkpoint_segments = 128 bgwriter_percent = 0 bgwriter_maxpages = 0
And also for /etc/system on Solaris 10, 9 SPARC use the following
set maxphys=1048576 set md:md_maxphys=1048576 set segmap_percent=50 set ufs:freebehind=0 set msgsys:msginfo_msgmni = 3584 set semsys:seminfo_semmni = 4096 set shmsys:shminfo_shmmax = 15392386252 set shmsys:shminfo_shmmni = 4096
Try using the -fast compile flag. The binaries might not be portable to other Solaris systems, and you might need to compile everything that links to PostgreSQL with -fast, but PostgreSQL will run significantly faster, 50% faster on some tests.