CLONE TABLE DATA TO - Mailing list 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>