Simon Riggs <simon@2ndquadrant.com> writes:
> I agree, hence why this should be a user option. The usage of this is
> restricted to particular classes of database usage: data warehousing or
> very large database applications. This isn't intended for use in OLTP or
> web-site databases.
Well a lot of users also just don't use online backups. For these users
there's no downside to CREATE INDEX/REINDEX/CREATE TABLE AS not logging.
The logging is not needed for a regular recovery, only for restoring from
and a backup older than the table/index creation.
--
greg