Re: Feature proposal

From: Eric Comeau <ecomeau(at)signiant(dot)com>
To: Denis BUCHER <dbucherml(at)hsolutions(dot)ch>
Cc: wstrzalka <wstrzalka(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Feature proposal
Date: 2010-08-25 16:20:40
Message-ID: 1282753240.4927.1.camel@ecomeau-ubun
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-08-25 16:28:20 Re: initdb fails to allocate shared memory
Previous Message bricklen 2010-08-25 15:57:27 Re: unexpected message type 0x58 during COPY from stdin