On Tue, Dec 19, 2017 at 2:57 AM, Robert Haas <robertmh...@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
