Re: Gauging progress of COPY?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Gauging progress of COPY?
Date: 2022-01-21 19:50:53
Message-ID: 20220121195052.GJ10577@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings,

* Ron (ronljohnsonjr(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2022-01-22 07:16:23 Determine potential change in table size after a column dropped?
Previous Message Stephen Frost 2022-01-21 19:50:07 Re: Password authorization