Re: Questions about large objects and the WAL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Questions about large objects and the WAL
Дата
Msg-id 7068.1141194161@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Questions about large objects and the WAL  (Karen Ploski <ploskikl@yahoo.com>)
Список pgsql-general
Karen Ploski <ploskikl@yahoo.com> writes:
> I'm trying to understand how large objects relate to
> the write-ahead log.

Large objects are just some data in a table.  The API for them is a bit
odd, but the reliability issues are not any different from any other
transaction.

> (1)When a large object is updated, how much of the
> large object is placed in the WAL buffers in shared
> memory by LogInsert?

Every row you updated (which is any 2K segment of the
large object IIRC).

            regards, tom lane

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Data corruption zero a file - help!!
Следующее
От: Roman Neuhauser
Дата:
Сообщение: Re: majordomo unmaintained, postmaster emails ignored?