Re: code question: storing INTO relation
От | Michael Paesold |
---|---|
Тема | Re: code question: storing INTO relation |
Дата | |
Msg-id | 028d01c4b863$c6e00620$ad01a8c0@zaphod обсуждение исходный текст |
Ответ на | code question: storing INTO relation (Neil Conway <neilc@samurai.com>) |
Ответы |
Re: code question: storing INTO relation
|
Список | pgsql-hackers |
Greg Stark wrote: > 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
В списке pgsql-hackers по дате отправления: