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