Re: [PERFORM] Postgres on Netapp
On January 16, 2004 11:53 am, Larry Rosenman wrote: --On Monday, January 12, 2004 13:45:45 -0800 Shankar K [EMAIL PROTECTED] 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 [EMAIL PROTECTED]|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. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [PERFORM] Postgres on Netapp
--On Monday, January 12, 2004 13:45:45 -0800 Shankar K [EMAIL PROTECTED] wrote: Hi There, We are considering to use NetApp filer for a highly busy 24*7 postgres database and the reason we chose netapp, mostly being the snapshot functionality for backing up database online. The filer would be mounted on a rh linux server (7.3), 4g RAM, dual cpu with a dedicated card for filer. I'd appreciate if anyone could share your experience in configuring things on the filer for optimal performance or any recomendataion that i should be aware of. I run a (not very busy) PG cluster on a NetAPP. 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. LER Thanks, Shankar __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 pgp0.pgp Description: PGP signature