Re: wal archive peak during pg_dump

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: wal archive peak during pg_dump
Дата
Msg-id CAKoxK+4q4AerC0etsHg9Evuy__wSBWuth_tK0fLwpz7BkQb=XA@mail.gmail.com
обсуждение исходный текст
Ответ на wal archive peak during pg_dump  (Willy-Bas Loos <willybas@gmail.com>)
Список pgsql-general
On Thu, Jan 9, 2014 at 11:42 AM, Willy-Bas Loos <willybas@gmail.com> wrote:

> It doesn't seem logical to me that pg_dump should generate wal, but i
> haven't been able to find a different explanation so far.
> So to make sure, i want to ask you people: can it be that running pg_dump
> creates a lot of wal?

Interesting. pg_dump works in a transactional model, but it should be
on read only. Is it possible you have dirty pages that are made
persistent due to pg_dump? Or could it be a vacuum process or
something related to freezing the tuples?

Luca


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

Предыдущее
От: "ygnhzeus"
Дата:
Сообщение: How to specify/mock the statistic data of tables in PostgreSQL
Следующее
От: Rémi Cura
Дата:
Сообщение: excution time for plpgsql function and subfunction