Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id CBFF72E0074 for ; Fri, 11 Apr 2008 17:26:27 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 47534-03 for ; Fri, 11 Apr 2008 17:26:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from westnet.com (westnet.com [216.187.52.2]) by developer.postgresql.org (Postfix) with ESMTP id BA06E2E0081 for ; Fri, 11 Apr 2008 17:26:24 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m3BKQNHq003326; Fri, 11 Apr 2008 16:26:23 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m3BKQN2V003322; Fri, 11 Apr 2008 16:26:23 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Fri, 11 Apr 2008 16:26:23 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: MUNAGALA REDDY cc: pgsql-performance@postgresql.org Subject: Re: Performance is low Postgres+Solaris In-Reply-To: <990745.76438.qm@web50503.mail.re2.yahoo.com> Message-ID: References: <990745.76438.qm@web50503.mail.re2.yahoo.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/161 X-Sequence-Number: 29654 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 gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD