Re: WAL to RAW devices ?

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: WAL to RAW devices ?
Дата
Msg-id
4778.1188605290@sss.pgh.pa.us
Ответ на
Re: WAL to RAW devices ? (Alex Vinogradovs)
Список
Дерево обсуждения
URGENT: Whole DB down ("no space left on device") "Phoenix Kiula" <phoenix.kiula@gmail.com>
Re: URGENT: Whole DB down ("no space left on device") Tommy Gildseth <tommy.gildseth@usit.uio.no>
Re: URGENT: Whole DB down ("no space left on device") Bruce McAlister <bruce.mcalister@blueface.ie>
Re: URGENT: Whole DB down ("no space left on device") Zoltan Boszormenyi <zb@cybertec.at>
Re: URGENT: Whole DB down ("no space left on device") "Phoenix Kiula" <phoenix.kiula@gmail.com>
Re: URGENT: Whole DB down ("no space left on device") Erik Jones <erik@myemma.com>
Re: URGENT: Whole DB down ("no space left on device") "Josh Tolley" <eggyknap@gmail.com>
Re: URGENT: Whole DB down ("no space left on device") "Phoenix Kiula" <phoenix.kiula@gmail.com>
Re: URGENT: Whole DB down ("no space left on device") Jeff Davis <pgsql@j-davis.com>
WAL to RAW devices ? Alex Vinogradovs <AVinogradovs@clearpathnet.com>
Re: WAL to RAW devices ? Tom Lane <tgl@sss.pgh.pa.us>
Re: WAL to RAW devices ? Alex Vinogradovs <AVinogradovs@Clearpathnet.com>
Re: WAL to RAW devices ? Alvaro Herrera <alvherre@commandprompt.com>
Re: WAL to RAW devices ? Alex Vinogradovs <AVinogradovs@Clearpathnet.com>
Re: WAL to RAW devices ? Alvaro Herrera <alvherre@commandprompt.com>
Re: WAL to RAW devices ? Alex Vinogradovs <AVinogradovs@Clearpathnet.com>
Re: WAL to RAW devices ? Tom Lane <tgl@sss.pgh.pa.us>
Re: WAL to RAW devices ? Alex Vinogradovs <AVinogradovs@Clearpathnet.com>
Re: WAL to RAW devices ? "Joshua D. Drake" <jdrake@postgresql.org>
Re: WAL to RAW devices ? "Joshua D. Drake" <jd@commandprompt.com>
Re: WAL to RAW devices ? Alex Vinogradovs <AVinogradovs@Clearpathnet.com>
Re: URGENT: Whole DB down ("no space left on device") "Anton Melser" <melser.anton@gmail.com>
Re: URGENT: Whole DB down ("no space left on device") "Merlin Moncure" <mmoncure@gmail.com>
Alex Vinogradovs  writes:
> WAL segments already have their structure. Filesystem would be an
> overhead,

Just because you'd like that to be true doesn't make it true.  We have
to manage a variable number of active segments; track whether a given
segment is waiting for future use, active, waiting to be archived, etc;
manage status signaling to the archiver process; and so on.  Now I'll
freely admit that using a filesystem is only one of the ways that those
problems could be attacked, but that's how they've been attacked in
Postgres.  If you want to not have that functionality present then
you'd need to rewrite all that code and provide some other
infrastructure for it to use.

			regards, tom lane
В списке pgsql-general по дате отправления
От: Alex Vinogradovs
Дата:
Сообщение: Re: WAL to RAW devices ?
От: Alex Vinogradovs
Дата:
Сообщение: Re: WAL to RAW devices ?
FAQ