X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2093AD1B2D9 for ; Tue, 22 Jun 2004 08:26:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76430-01 for ; Tue, 22 Jun 2004 11:26:03 +0000 (GMT) Received: from planae.com.br (nat.planae.com.br [200.210.129.190]) by svr1.postgresql.org (Postfix) with SMTP id 54E56D1B20E for ; Tue, 22 Jun 2004 08:25:57 -0300 (ADT) Received: (qmail 38674 invoked by uid 85); 22 Jun 2004 11:29:10 -0000 Received: from unknown (HELO smannote) (192.168.0.207) by 192.168.0.3 with SMTP; 22 Jun 2004 11:29:06 -0000 Message-ID: <00c201c4584b$b6f09c70$cf00a8c0@smannote> From: "Carlos Eduardo Smanioto" To: "Scott Marlowe" , "Andrew Rawnsley" Cc: "Andrew Hammond" , References: <40D722CC.8000905@ca.afilias.info> <644E3D69-C3F6-11D8-8816-000393A47FCC@ravensfield.com> <1087876005.1187.941.camel@localhost.localdomain> Subject: Re: Postgres over Linux NBD or NFS Date: Tue, 22 Jun 2004 08:25:38 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 1 X-MSMail-Priority: High X-Mailer: Microsoft Outlook Express 6.00.3718.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3718.0 X-Virus-Scanned: by AMaViS 0.3.12 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=X_MSMAIL_PRIORITY_HIGH, X_PRIORITY_HIGH X-Spam-Level: * X-Archive-Number: 200406/297 X-Sequence-Number: 7355 Anselmo bom dia! Não é custoso monstar um Cluster (Storage caseiro) em PostgreSQL, Está em discussão no forum da PostgreSQL a possíbilidade de usar o NFS (Network file system) ou o NBD (Network Block Device), ambos consistem em "Mapear" a partição de dados do PostgreSQL em uma OUTRA máquina com PostgreSQL a fim de que os as duas máquinas trabalhem com a mesma base de dados. Carlos Eduardo Smanioto Infra Estrutura - Servidores e Segurança Planae - Tecnologia da Informação Fone/Fax +55 14 3224-3066 Ramal 207 www.planae.com.br ----- Original Message ----- From: "Scott Marlowe" To: "Andrew Rawnsley" Cc: "Andrew Hammond" ; Sent: Tuesday, June 22, 2004 12:46 AM Subject: Re: [PERFORM] Postgres over Linux NBD or NFS > On Mon, 2004-06-21 at 20:46, Andrew Rawnsley wrote: > > On Jun 21, 2004, at 2:02 PM, Andrew Hammond wrote: > > > > > -----BEGIN PGP SIGNED MESSAGE----- > > > Hash: SHA1 > > > > > > We're looking for an alternative to fiber-channel disk arrays for mass > > > storage. One of the ideas that we're exploring would involve having the > > > cluster on an NFS mounted filesystem. Another technology we're looking > > > at is the Linux NBD (Network Block Device). > > > > > > > No idea about NBDs, but its generally accepted that running over NFS > > would significantly > > decrease reliability and performance, i.e. it would be a Bad Move (tm). > > Not sure what you > > think to gain. I sure wouldn't trust NFS with a production database. > > > > What exactly are you trying to gain, avoid, or do? > > I've gotten good performance over NFS using switched 100, then later > gigabit. But I wouldn't trust it for diddly. > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings