pg_logical/snapshots directory

From: Mark Fletcher <markf(at)corp(dot)groups(dot)io>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pg_logical/snapshots directory
Date: 2017-11-04 17:45:21
Message-ID: CAEO096p5ERU8=j9vvmVEJ6=0ByiaRPjDu5Tq=7tcGfuUZ9X8+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Lakes 2017-11-05 03:57:16 ERROR: invalid input syntax for integer: "INSERT"
Previous Message Marc-Olaf Jaschke 2017-11-04 16:41:38 A possible use case for: "INSERT .. ON CONFLICT DO SELECT [FOR ..]"