Le 25.08.2010 09:15, wstrzalka a écrit :
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.
Or maybe there is some way to do it? As long as postgres have no read-
uncommited I think I can estimate it only by destination table size ??
By the way, did you try to optimize your postgresql server ?
In my case I was able to reduce a big data update from :
1 hour 15 minutes
to :
5 minutes
Without even changing any line of data or code in sql !
Incredible, isn't it ?
Denis
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
