Re: Gauging progress of COPY?
От
Tom Lane
Тема
Re: Gauging progress of COPY?
Дата
Msg-id
892470.1642702398@sss.pgh.pa.us
Ответ на
Gauging progress of COPY? (Wells Oliver)
Список
Дерево обсуждения
Gauging progress of COPY? Wells Oliver <wells.oliver@gmail.com>
Re: Gauging progress of COPY? Ron <ronljohnsonjr@gmail.com>
Re: Gauging progress of COPY? Stephen Frost <sfrost@snowman.net>
Re: Gauging progress of COPY? Tom Lane <tgl@sss.pgh.pa.us>
Re: Gauging progress of COPY? Magnus Hagander <magnus@hagander.net>
Re: Gauging progress of COPY? Greg Spiegelberg <gspiegelberg@gmail.com>
Wells Oliver writes: > Is there some clever way to gauge the progress of a COPY command? i.e. you > know it has 10m rows, but you can't SELECT COUNT(*). If it's a COPY IN (to a table) you could monitor growth of the physical size of the table, cf pg_relation_size(). This isn't terribly satisfactory if you're not clear on how much space each row will take, but it's something. regards, tom lane
В списке pgsql-admin по дате отправления
