Postgres Pro
Downloads
Home   >   mailing lists

Moving postgres to FC disks - Mailing list pgsql-performance

From Anjan Dave
Subject Moving postgres to FC disks
Date
Msg-id 4BAFBB6B9CC46F41B2AD7D9F4BBAF78509814D@vt-pe2550-001.vantage.vantage.com
Whole thread Raw
Responses Re: Moving postgres to FC disks  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance
Tree view

I am planning to move the pg databases from the internal RAID to external Fiber Channel over SAN.

 

Question is –

 

-With the db size being as big as, say, 30+GB, how do I move it on the new logical drive? (stop postgresql, and simply move it over somehow and make a link?)

-Currently, the internal RAID volume is ext3 filesystem. Any recommendations for the filesystem on the new FC volume? Rieserfs?

 

DBs are 7.4.1(RH9), and 7.2.3 (RH8).

 

 

Appreciate any pointers.

 

Thanks,
Anjan

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Use of subquery causes seq scan???
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Horribly slow hash join