Re: Feature proposal
От | Eric Comeau |
---|---|
Тема | Re: Feature proposal |
Дата | |
Msg-id | 1282753240.4927.1.camel@ecomeau-ubun обсуждение исходный текст |
Ответ на | Re: Feature proposal (Denis BUCHER <dbucherml@hsolutions.ch>) |
Ответы |
Re: Feature proposal
Re: Feature proposal |
Список | pgsql-general |
On Wed, 2010-08-25 at 17:06 +0200, Denis BUCHER wrote: > 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 ? > Curious- what postgresql.conf settings did you change to improve it?
В списке pgsql-general по дате отправления: