От: D'Arcy J.M. Cain
Тема: Re: Postgres on Netapp
Дата: ,
Msg-id: 200401171155.13281.darcy@druid.net
(см: обсуждение, исходный текст)
Ответ на: Re: Postgres on Netapp  (Larry Rosenman)
Ответы: Re: Postgres on Netapp  (Bruce Momjian)
Список: pgsql-performance

Скрыть дерево обсуждения

Postgres on Netapp  (Shankar K, )
 Re: Postgres on Netapp  (Larry Rosenman, )
  Re: Postgres on Netapp  ("D'Arcy J.M. Cain", )
   Re: Postgres on Netapp  (Bruce Momjian, )
 Re: Postgres on Netapp  (Rod Taylor, )

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.


> 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.

В списке pgsql-performance по дате сообщения:

От: John Siracusa
Сообщение: Re: Idle postmaster taking up a lot of CPU
От: Ceri Storey
Сообщение: Re: Join optimisation Quandry