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