CLONE TABLE DATA TO
От | Marc Mamin |
---|---|
Тема | CLONE TABLE DATA TO |
Дата | |
Msg-id | C4DAC901169B624F933534A26ED7DF310861B2BC@JENMAIL01.ad.intershop.net обсуждение исходный текст |
Ответы |
Re: CLONE TABLE DATA TO |
Список | pgsql-hackers |
<p dir="LTR"><span lang="de"></span><span lang="en-us"><font face="Calibri">Hello,</font></span><p dir="LTR"><span lang="en-us"><fontface="Calibri">I wonder if it would be possible to have a fast table clone function (data only) while copyingthe corresponding data files</font></span><p dir="LTR"><span lang="en-us"><font face="Calibri">inst</font></span><spanlang="de"></span><span lang="en-us"><font face="Calibri">e</font></span><span lang="de"></span><spanlang="en-us"><font face="Calibri">ad of using the "CREATE TABLE AS" way.</font></span><p dir="LTR"><spanlang="de"></span><span lang="de"></span><span lang="de"></span><span lang="de"></span><span lang="en-us"><fontface="Calibri">pg_upgrade</font></span><span lang="de"></span><span lang="de"></span><span lang="de"></span><spanlang="en-us"> <font face="Calibri">seems to have such a mechanisms,</font></span><span lang="de"></span><spanlang="de"></span><span lang="de"></span><span lang="en-us"> <font face="Calibri">though it requiresto first stop the server...</font></span><span lang="de"></span><span lang="de"></span><span lang="de"></span><spanlang="en-us"></span><p dir="LTR"><span lang="de"></span><span lang="de"></span><span lang="en-us"><fontface="Calibri">This would of course require to lock the complete table and ensure that all latest changesare flushed to the plates.</font></span><span lang="de"></span><span lang="en-us"></span><p dir="LTR"><span lang="de"></span><spanlang="de"></span><span lang="de"></span><span lang="de"></span><span lang="en-us"><font face="Calibri">Idon't know how are the plan about switching</font></span><span lang="de"></span><span lang="de"></span><spanlang="de"></span><span lang="en-us"> <font face="Calibri"> from</font></span><span lang="de"></span><spanlang="de"></span><span lang="de"></span><span lang="en-us"> <font face="Calibri">UNLOGGED</font></span><spanlang="de"></span><span lang="de"></span><span lang="de"></span><span lang="en-us"><font face="Calibri">to LOGGED tab</font></span><span lang="de"></span><span lang="de"></span><span lang="de"></span><spanlang="en-us"><font face="Calibri">les, but I guess this might be required</font></span><span lang="de"></span><spanlang="de"></span><span lang="de"></span><span lang="en-us"> <font face="Calibri">to start logging thetable only after the copy.</font></span><span lang="de"></span><span lang="de"></span><span lang="de"></span><span lang="en-us"></span><pdir="LTR"><span lang="de"></span><span lang="de"></span><span lang="en-us"></span><p dir="LTR"><spanlang="en-us"><font face="Calibri">Background: I have daily tables with hourly imports which may contain >100 Mio rows and require 7 indices on them.</font></span><p dir="LTR"><span lang="en-us"><font face="Calibri">In orderto improve import performances, I first do a copy of the active</font></span><span lang="de"></span><span lang="en-us"><fontface="Calibri"></font></span><span lang="de"></span><span lang="en-us"> <font face="Calibri">table, importnew data and rebuild the indexes.</font></span><p dir="LTR"><span lang="de"></span><span lang="en-us"></span><p dir="LTR"><spanlang="de"></span><span lang="en-us"></span><p dir="LTR"><span lang="de"></span><span lang="en-us"><font face="Calibri">Thanksfor your great job,</font></span><p dir="LTR"><span lang="en-us"><font face="Calibri">Marc Mamin</font></span><uldir="LTR"><p dir="LTR"><span lang="de"></span><span lang="en-us"></span></ul>
В списке pgsql-hackers по дате отправления: