On 2019-11-05 22:16, Robert Haas wrote:
> First, I'd like to restate my understanding of the problem just to see
> whether I've got the right idea and whether we're all on the same
> page. When wal_level=minimal, we sometimes try to skip WAL logging on
> newly-created relations in favor of fsync-ing the relation at commit
> time.
How useful is this behavior, relative to all the effort required?
Even if the benefit is significant, how many users can accept running
with wal_level=minimal and thus without replication or efficient backups?
Is there perhaps an alternative approach involving unlogged tables to
get a similar performance benefit?
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services