Re: CLONE TABLE DATA TO
| От | Robert Haas |
|---|---|
| Тема | Re: CLONE TABLE DATA TO |
| Дата | |
| Msg-id | CA+TgmoaGC4LG3Haut7d6tgKm17HhB2SbA73J-JG2nps3_b1Hpg@mail.gmail.com обсуждение исходный текст |
| Ответ на |
CLONE TABLE DATA TO |
| Ответы |
Re: CLONE TABLE DATA TO |
| Список | pgsql-hackers |
On Fri, Jan 13, 2012 at 5:56 AM, Marc Mamin <M.Mamin@intershop.de> wrote: > I wonder if it would be possible to have a fast table clone function (data > only) while copying the corresponding data files > > instead of using the "CREATE TABLE AS" way. > > pg_upgrade seems to have such a mechanisms, though it requires to first stop > the server... > > This would of course require to lock the complete table and ensure that all > latest changes are flushed to the plates. I think it would be possible to implement this. In fact, it could probably be done as a contrib module. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления: