From: Greg Smith <gsmith@gregsmith.com>
To: MUNAGALA REDDY <munagalar@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance is low Postgres+Solaris
Date: Fri, 11 Apr 2008 16:26:23 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0804111622140.2065@westnet.com> (raw)
In-Reply-To: <990745.76438.qm@web50503.mail.re2.yahoo.com>
References: <990745.76438.qm@web50503.mail.re2.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gsmith@gregsmith.com, munagalar@yahoo.com
Subject: Re: Performance is low Postgres+Solaris
In-Reply-To: <Pine.GSO.4.64.0804111622140.2065@westnet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox