Tom Lane <tgl@xxxxxxxxxxxxx> writes: > Alan Stange <stange@xxxxxxxxxx> writes: >> Gregory Stark wrote: >>> AFAIK Opensolaris doesn't implement posix_fadvise() so there's no benefit. > >> It's implemented. I'm guessing it's not what you want to see though: >> http://src.opensolaris.org/source/xref/onnv/onnv-gate/usr/src/lib/libc/port/gen/posix_fadvise.c > > Ugh. So apparently, we actually need to special-case Solaris to not > believe that posix_fadvise works, or we'll waste cycles uselessly > calling a do-nothing function. Thanks, Sun. Do we? Or do we just document that setting effective_cache_size on Solaris won't help? I'm leaning towards the latter because I expect Sun will implement this and there will be people running 8.4 on newer versions of the OS long after it's out. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance