On Thu, 3 Apr 2008, MUNAGALA REDDY wrote:
We are using solaris 10 x86/AMD Opteron and postgresql 8.2 on SunFire X2100 , however performance is very slow in contrast to linux debian in the same platform.
There are some significant differences between how Solaris caches database files in both of its major filesystems (UFS and ZFS) compared to how Linux handles caching. Linux is much more aggressive in using lots of memory effectively for database caching compared to an untuned Solaris 10.
I'd recommend the just published talk at http://blogs.sun.com/jkshah/entry/postgresql_east_2008_talk_best for an introduction to the details; the information at pages 8 and 9 there I found particularly informative.
-- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
