PDA

View Full Version : Installing PostgreSQL on another partition



agc1976
09-14-2008, 11:26 AM
I'm considering creating another partition on my hard drive just for PostgreSQL. The main objective is to slightly improve performance. My thoughts are the following:

1. Having the DB on a different partition means that It will cause less fragmentation on my system drive and vice versa.
2. It will be much faster to defrag the PGSQL partition than having to defrag the whole computer.
3. Reduce clutter in my program files directory.

Does this make sense?

I know the optimum way to achieve this is by having it on a separate hard drive, but this is not possible at the moment.

fabio
09-14-2008, 11:52 AM
Sounds good

thor
11-29-2009, 11:07 AM
At one point Roy told me that the Windows chkdsk function was not good for HEM and its execution after a failed shutdown may have caused an issue within my HEM.

Is defragging (Windows or not) OK to use on your HEM partition?

netsrak
11-29-2009, 12:22 PM
Yes its ok, but you need to stop the postgresql services before doing this.