pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: D'Arcy J.M. Cain <darcy@druid.net>
To: Larry Rosenman <ler@lerctr.org>
To: Shankar K <shan0075@yahoo.com>
Cc: pgsql-performance@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [PERFORM] Postgres on Netapp
Date: Sat, 17 Jan 2004 11:55:13 -0500
Message-ID: <200401171155.13281.darcy@druid.net> (raw)
In-Reply-To: <92970000.1074271998@lerlaptop-red.iadfw.net>
References: <20040112214545.35952.qmail@web21106.mail.yahoo.com>
	<92970000.1074271998@lerlaptop-red.iadfw.net>

On January 16, 2004 11:53 am, Larry Rosenman wrote:
> --On Monday, January 12, 2004 13:45:45 -0800 Shankar K <shan0075@yahoo.com>
> 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 <darcy@{druid|vex}.net>   |  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.



view thread (5+ messages)  latest in thread

Message-ID: <200401171155.13281.darcy@druid.net>
Permalink:  ../200401171155.13281.darcy@druid.net/
Also on:    postgresql.org/message-id/200401171155.13281.darcy@druid.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: darcy@druid.net, ler@lerctr.org, shan0075@yahoo.com, pgsql-admin@postgresql.org
  Subject: Re: [PERFORM] Postgres on Netapp
  In-Reply-To: <200401171155.13281.darcy@druid.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox