Re: SSDs with Postgresql?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SSDs with Postgresql?
Дата
Msg-id 24484.1303402938@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: SSDs with Postgresql?  (Florian Weimer <fweimer@bfk.de>)
Ответы Re: SSDs with Postgresql?
Список pgsql-general
Florian Weimer <fweimer@bfk.de> writes:
> * Adrian Klaver:
>>> Interesting.  Is there an easy way to monitor WAL traffic in away?

>> They are found in $DATA/pg_xlog so checking the size of that
>> directory regularly would get you the information.

> But log files are recycled, so looking at the directory alone does not
> seem particularly helpful.

"du" would be useless, but you could check the name of the newest WAL
segment file from time to time, and do a bit of math to see how much
WAL had been written since the previous time.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: SSDs with Postgresql?
Следующее
От: "Bob Pawley"
Дата:
Сообщение: Re: Different views of remote server