In Postgres CREATE TABLE AS is currently being treated as a synonym for SELECT
... INTO ... So I think this may be an awkward feature to add. Also, like
reindex the logging would still be necessary for online backups. So this may
be a dead-end direction in the long term.
Putting aside the CREATE TABLE AS/SELECT ... INTO vs INSERT ... SELECT confusion, online backups seem to be an issue.
Is there any command currently, that circumvents WAL and the result is still consistent with PITR? How is this done in other databases?
Implementing features that don't work with PITR does not feel right at all, of course, since eventually many if not most of the people will use continues logging.
Best Regards,
Michael
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
