X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 557EBD1DF9E; Fri, 16 Jan 2004 16:55:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 67200-05; Fri, 16 Jan 2004 12:54:30 -0400 (AST) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by svr1.postgresql.org (Postfix) with ESMTP id 605D6D1B49A; Fri, 16 Jan 2004 12:53:36 -0400 (AST) Received: from lerlaptop-red.iadfw.net ([207.136.3.72]) by lerami.lerctr.org with asmtp (Exim 4.30) id 1AhXDj-0006EA-GK; Fri, 16 Jan 2004 10:53:19 -0600 Date: Fri, 16 Jan 2004 10:53:18 -0600 From: Larry Rosenman To: Shankar K , pgsql-admin@postgresql.org Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Postgres on Netapp Message-ID: <92970000.1074271998@lerlaptop-red.iadfw.net> In-Reply-To: <20040112214545.35952.qmail@web21106.mail.yahoo.com> References: <20040112214545.35952.qmail@web21106.mail.yahoo.com> X-Mailer: Mulberry/3.1.0 (Linux/x86) X-PGP-Info: All other keys are old/dead. X-PGP-Key: 0x3c49bdd6 X-PGP-Fingerprint: D0D1 3C11 F42F 6B29 FA67 6BF3 AD13 4685 3C49 BDD6 MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="==========00FA25CBFB091042FB03==========" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/148 X-Sequence-Number: 12011 --==========00FA25CBFB091042FB03========== Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline --On Monday, January 12, 2004 13:45:45 -0800 Shankar K = =20 wrote: > Hi There, > > We are considering to use NetApp filer for a highly > busy 24*7 postgres database and the reason we chose > netapp, mostly being the "snapshot" functionality for > backing up database online. The filer would be mounted > on a rh linux server (7.3), 4g RAM, dual cpu with a > dedicated card for filer. > > I'd appreciate if anyone could share your experience > in configuring things on the filer for optimal > performance or any recomendataion that i should be > aware of. I run a (not very busy) PG cluster on a NetAPP. It seems to do just fine. The issue is the speed of the network connection. In my case it's only FastEthernet (100BaseTX). If it's very busy, you may need to look at GigE. LER > > Thanks, > Shankar > > __________________________________ > Do you Yahoo!? > Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes > http://hotjobs.sweepstakes.yahoo.com/signingbonus > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > --=20 Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 --==========00FA25CBFB091042FB03========== Content-Type: application/pgp-signature Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQFACBb+rRNGhTxJvdYRAljlAJ0Y93a1OY0CVU3Ol5DagPVoOL5MTgCfYNzh 94NSOSnYIrjLULLGr5z7fZ0= =44yj -----END PGP SIGNATURE----- --==========00FA25CBFB091042FB03==========--