I need to know if anyone out there is/has run their PostgreSQL on NetApp
arrays via NFS. My particular situation is RH Linux 4 servers running
Postgresql 8.1. I need
to provide our Operations manager with specific reasons why we should not
run PostgreSQL over NetApp NFS. Otherwise, they
Have you tried a different kernel? We run with a
netapp over NFS without any issues, but we have seen high IO-wait on other Dell
boxes (running and not running postgres) and RHES 3. We have
replaced a Dell PowerEdge 350 running RH 7.3 with a PE750 with more memory
running RHES3 and it be
Andrew,
What version of Redhat are you running? We have found running Enterprise
Update 3 kernel kills our Dell boxes with IOWait, both NFS and local disk
traffic. Update 2 kernel does not seem to have the issue, and we are in the
process of trying Update 4 beta to see if it is better.
PM
To: [EMAIL PROTECTED]
Cc: Woody Woodring; 'Andrew Janian'
Subject: Re: [PERFORM] Query Performance and IOWait
Woody,
What version of Redhat are you running? We have found running
Enterprise Update 3 kernel kills our Dell boxes with IOWait, both NFS
and local disk traffic. Update 2 kernel
Hello,
I am using postgres 7.4.2 as a backend for geocode data for a mapping
application. My question is why can't I get a consistent use of my indexes
during a query, I tend to get a lot of seq scan results.
I use a standard query:
SELECT lat, long, mac, status FROM (
SELECT text(mac) as