Обсуждение: pg_xlog on same drive as OS

Поиск
Список
Период
Сортировка

pg_xlog on same drive as OS

От
mallah@trade-india.com
Дата:
greetings!
on a dedicated pgsql server is putting pg_xlog
in drive as OS almost equivalent to putting on a seperate
drive?


in both case the actual data files are in a seperate
drive.

regds
mallah

Re: pg_xlog on same drive as OS

От
Josh Berkus
Дата:
Mallah,

> on a dedicated pgsql server is putting pg_xlog
> in drive as OS almost equivalent to putting on a seperate
> drive?

Yes.   If I have limited drives, this is what I do.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


Re: pg_xlog on same drive as OS

От
Christopher Browne
Дата:
In the last exciting episode, mallah@trade-india.com wrote:
> greetings!
> on a dedicated pgsql server is putting pg_xlog
> in drive as OS almost equivalent to putting on a seperate
> drive?
>
> in both case the actual data files are in a seperate
> drive.

Well, if the OS drive is relatively inactive, then it may be "separate
enough" that you won't find performance hurt too much by this.
--
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me
http://cbbrowne.com/info/postgresql.html
MICROS~1 is not the answer.
MICROS~1 is the question.
NO (or Linux) is the answer.