Solaris

Installation guide

Installation notes

Update postgres.conf

autovacuum is not turned off (it's on by default)

Improvements for COPY

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

Run analyse

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.