Re: Horrible PostgreSQL performance with NFS

To: freebsd-performance@xxxxxxxxxxx, freebsd-database@xxxxxxxxxxx
Subject: Re: Horrible PostgreSQL performance with NFS
From: Slawek Zak <slawek.zak@xxxxxxxxx>
Date: Tue, 17 Jan 2006 10:57:09 +0100
Cc:
Delivered-to: freebsd-performance@xxxxxxxxxxx
Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=CAXgYPOr2nJaYKXiOsLSD2eKcFcDNrRO3tOeX/IGZqG1F+PzBUfUfEN/rQebCxO19R+/AumBiE5FenDBJMS6Hgy6gZqVimz9Erc3MUm2S9zWXS2VTLzuiKL92Ll8Xo9dNVi05gBwPXGoGdfPByhCPgbdTeOPKS00HQAvelxNAYw=
In-reply-to: <787bbe1c0601150650n664f8114o89ea37bf50e7dac7@xxxxxxxxxxxxxx>
List-archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-id: Performance/tuning <freebsd-performance.freebsd.org>
List-post: <mailto:freebsd-performance@freebsd.org>
List-subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>, <mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
List-unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>, <mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
References: <43C9110B.8070807@xxxxxx> <20060114161402.43003.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxxx> <787bbe1c0601150650n664f8114o89ea37bf50e7dac7@xxxxxxxxxxxxxx>

Hi,

I went back one step and moved the db back to the disks. It seems that
an unrelated update to the database at around the same time I migrated
to filer, made it slow down to a crawl. After some tweaking by the
developers and moving back to filer, performance is fine again.

Lesson learned: Always one step at a time.

Sorry for the havoc.

/S
--
Sławek Żak / UNIX Systems Administrator

Follow-Ups:
- Re: Horrible PostgreSQL performance with NFS
  - From: Nash Nipples

References:
- Re: Horrible PostgreSQL performance with NFS
  - From: Ivan Voras
- Re: Horrible PostgreSQL performance with NFS
  - From: Arne Woerner
- Re: Horrible PostgreSQL performance with NFS
  - From: Slawek Zak

Prev by Date: Re: Horrible PostgreSQL performance with NFS
Next by Date: Re: Horrible PostgreSQL performance with NFS
Previous by thread: Re: Horrible PostgreSQL performance with NFS
Next by thread: Re: Horrible PostgreSQL performance with NFS
Index(es):
- Date
- Thread