Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] Postgres on Netapp

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
Cc: Larry Rosenman <ler(at)lerctr(dot)org>, Shankar K <shan0075(at)yahoo(dot)com>,pgsql-performance(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [PERFORM] Postgres on Netapp
Date: 2004-01-23 15:01:09
Message-ID: 200401231501.i0NF19B08501@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-performance
D'Arcy J.M. Cain wrote:
> 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.

PostgreSQL has to read the WAL to adjust the contents of the flat file
on startup in such a setup, so I don't see how we could do it read-only.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-performance by date

Next:From: Dave ThompsonDate: 2004-01-23 16:43:28
Subject: High Performance/High Reliability File system on SuSE64
Previous:From: Arnau Rebassa i VillalongaDate: 2004-01-23 07:50:02
Subject: Queries with timestamp, 2

pgsql-admin by date

Next:From: Dave ThompsonDate: 2004-01-23 16:43:28
Subject: High Performance/High Reliability File system on SuSE64
Previous:From: StefDate: 2004-01-23 12:50:23
Subject: Re: [SQL] Fw: postgres logging [SOLVED]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group