t == [EMAIL PROTECTED] writes:
t> "Brandon Metcalf" <[EMAIL PROTECTED]> writes:
t> > We've been tuning the kernel (2.4 SMP flavor) and have improved
t> > performance quite a bit. I'm now wondering if turning off HT will
t> > improve performan
We're running a dual Xeon machine with hyperthreading enabled and
PostgreSQL 8.0.3. Below is the type of CPUs:
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping: 1
cpu MHz
I just wanted to follow up and let everyone know that the biggest
improvement in performance came from moving the pg_xlog directory to
another filesystem (different set of disks) separate from the data
directory.
Thanks for the suggestions.
--
Brandon
---(end of broadcas
a == [EMAIL PROTECTED] writes:
a> On Tue, Mar 22, 2005 at 03:23:18PM -0600, Brandon Metcalf wrote:
a> > s> What are you using to measure
a> > s> performance?
a> >
a> > Nothing too scientific other than the fact that since we have moved
a> > the D
s == [EMAIL PROTECTED] writes:
s> What are you using to create your raid?
Hm. I didn't set this up. I'll have to check.
s> You say it is "no doubt disk
s> I/O" - does iostat confirm this? A lot of performance issues are related
s> to the size of the stripe you chose for the striped portion
s == [EMAIL PROTECTED] writes:
s> Try setting
s> set ufs:ufs_WRITES=0
s> in /etc/system and rebooting, which basically says "any amount of disk
s> IO can be outstanding". There's a tunables doc on docs.sun.com that
s> explains this option.
s> Also, logging UFS might help with some of the m
We've recently moved our pgsql installation and DBs to a Solaris 8
machine with striped and mirrored ufs filesystem that houses the DB
data. We are now seeing terrible performance and the bottleneck is no
doubt disk I/O.
We've tried modifying a tunables related to ufs, but it doesn't seem
to be h
