[GENERAL] pg_logical/snapshots directory

Поиск
Список
Период
Сортировка
От Mark Fletcher
Тема [GENERAL] pg_logical/snapshots directory
Дата
Msg-id CAEO096p5ERU8=j9vvmVEJ6=0ByiaRPjDu5Tq=7tcGfuUZ9X8+w@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] pg_logical/snapshots directory  (Mark Fletcher <markf@corp.groups.io>)
Список pgsql-general
Дерево обсуждения
Hi All,

While trying to track down my logical decoding problem, I noticed that my pg_logical/snapshots directory has ~5000 .snap files and is growing at a rate of about 4 files a minute. The earliest file is from yesterday afternoon, dating to the time I took our site down and added a column to a large table.

I have not been able to find any docs on this directory. Can someone point me to an explanation of this directory and how to manage the number of .snap files in it (and/or whether I should be worried about the number of files in it)?

Thanks,
Mark

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

Предыдущее
От: Marc-Olaf Jaschke
Дата:
Сообщение: [GENERAL] A possible use case for: "INSERT .. ON CONFLICT DO SELECT [FOR ..]"
Следующее
От: Robert Lakes
Дата:
Сообщение: [GENERAL] ERROR: invalid input syntax for integer: "INSERT"