Re: Gauging progress of COPY? - Mailing list pgsql-admin

From Stephen Frost
Subject Re: Gauging progress of COPY?
Date
Msg-id 20220121195052.GJ10577@tamriel.snowman.net
Whole thread Raw
In response to Re: Gauging progress of COPY?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Greetings,

* Ron (ronljohnsonjr@gmail.com) wrote:
> On 1/20/22 12:00 PM, Wells Oliver wrote:
> >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(*).
>
> Use a specific tool like pg_bulkload.

Or maybe just use pv if you're doing it through psql or such.

Thanks,

Stephen

Attachment

pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Password authorization
Next
From: Wells Oliver
Date:
Subject: Determine potential change in table size after a column dropped?