From: | Adrian von Bidder <avbidder(at)fortytwo(dot)ch> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Feature proposal |
Date: | 2010-08-26 19:30:12 |
Message-ID: | 201008262130.26040@fortytwo.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Heyho!
On Wednesday 25 August 2010 09.15:33 wstrzalka wrote:
> I'm currently playing with very large data import using COPY from
> file.
>
> As this can be extremely long operation (hours in my case) the nice
> feature would be some option to show operation progress - how many
> rows were already imported.
Recently, I've found (on Linux, don't know if other OSs export this
information) /proc/<pid>/fdinfo/<fd> extremely helpful. It tells you the
position of the file pointer of file number <fd> in process <pid> (I guess
for a COPY import this would be the postgresql backend handling your import
session.)
Unlike other options, you can also use this if you only notice that the
process is long-running after you've already started it.
Of course it probably will not work if the file is mmapped or otherwise not
read in a sequential fashion.
cheers
-- vb
--
All Hail Discordia!
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2010-08-26 21:38:07 | Re: How to convert a binary filed to an integer field? |
Previous Message | Tom Lane | 2010-08-26 17:27:23 | Re: Differences between to_tsquery() and plainto_tsquery() when it comes to applying an index? |