Re: Tracking of page changes for backup purposes. PTRACK [POC] - Mailing list pgsql-hackers

On Tue, Dec 19, 2017 at 2:57 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> I think this doesn't really show much because it's apparently limited
> by the speed of fsync() on your filesystem.  You might try running the
> test with synchronous_commit=off.

You may want to run Postgres on scissors as much as possible by
decreasing checkpoint frequency. etc.

+    /*
+     * Do not track changes for unlogged and temp relations,
+     * since we are not going to backup them anyway.
+     */
+    if (rel->rd_rel->relpersistence != RELPERSISTENCE_PERMANENT)
+        return;
This is not true for init forks of unlogged tables, which are logged
and included in backups.
-- 
Michael