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 18C0AD1B4CE; Sat, 17 Jan 2004 16:55:48 +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 58385-07; Sat, 17 Jan 2004 12:55:17 -0400 (AST) Received: from druid.net (druid.net [216.126.72.98]) by svr1.postgresql.org (Postfix) with ESMTP id EDC7AD1B4D7; Sat, 17 Jan 2004 12:55:16 -0400 (AST) Received: by druid.net (Postfix, from userid 1000) id 3E98B1A9B; Sat, 17 Jan 2004 11:55:14 -0500 (EST) From: "D'Arcy J.M. Cain" To: Larry Rosenman , Shankar K Subject: Re: [PERFORM] Postgres on Netapp Date: Sat, 17 Jan 2004 11:55:13 -0500 User-Agent: KMail/1.5.4 Cc: pgsql-performance@postgresql.org, pgsql-admin@postgresql.org References: <20040112214545.35952.qmail@web21106.mail.yahoo.com> <92970000.1074271998@lerlaptop-red.iadfw.net> In-Reply-To: <92970000.1074271998@lerlaptop-red.iadfw.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200401171155.13281.darcy@druid.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/168 X-Sequence-Number: 12031 On January 16, 2004 11:53 am, Larry Rosenman wrote: > --On Monday, January 12, 2004 13:45:45 -0800 Shankar K > wrote: > > We are considering to use NetApp filer for a highly > > busy 24*7 postgres database and the reason we chose > I run a (not very busy) PG cluster on a NetAPP. I run a very busy PG installation on one. > It seems to do just fine. Ditto. > 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. With the price of GigE adapters I wouldn't consider anything else. I have a huge database that takes about an hour to copy. The netApp snapshot feature is very nice because I can get a "moment in time" image of the database. Even though I can't run from the snapshot because it is read only (*) and PG needs to write to files just to open the database, I can copy it and get a runnable version of the DB. If I copy directly from the original I can get many changes while copying and wind up with a copy that will not run. (*): It would be nice if PG had a flag that allowed a database to be opened in read only mode without touching anything in the directory. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.