BUG #8544: High nfs getattr

Started by Nonameover 12 years ago2 messagesbugs
Jump to latest
#1Noname
bentzi.mor@hp.com

The following bug has been logged on the website:

Bug reference: 8544
Logged by: bentzi
Email address: bentzi.mor@hp.com
PostgreSQL version: 9.2.3
Operating system: Redhat 6.3
Description:

While running postgres with NFS (like on netappp) we get between 5K - 30K
OPS while the read+write is only 10-20 OPS, means all recognize as other in
netapp.
While looking on postgres linux machine nfsstat show high getattr.

How to reduce it to get good performance and reduce load on the filer?

Bentzi

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Andres Freund
andres@anarazel.de
In reply to: Noname (#1)
Re: BUG #8544: High nfs getattr

Hi,

While running postgres with NFS (like on netappp) we get between 5K - 30K
OPS while the read+write is only 10-20 OPS, means all recognize as other in
netapp.
While looking on postgres linux machine nfsstat show high getattr.

You should enable attribute caching on the partition hosting postgres'
datadir.

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs