Re: Large table update/vacuum PLEASE HELP! - Mailing list pgsql-general

From Dmitry Tkach
Subject Re: Large table update/vacuum PLEASE HELP!
Date
Msg-id 3CBDBEB6.1070906@openratings.com
Whole thread Raw
In response to Re: Large table update/vacuum PLEASE HELP!  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Stephan Szabo wrote:

>
>
>For 1000 that should work, for much larger numbers you may need to play
>with settings to get an appropriate effect (you may see that as the number
>updated grows in order of magnitude that the wasted space approaches 2x as
>you the map of free space isn't large enough unless you up those
>settings).
>
I am sorry, I am afraid, I don't quite understand this. What exactly are
those settings I need to play with?
And what is this 'map of free space'?

Thanks a lot!

Dima





pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Large table update/vacuum PLEASE HELP!
Next
From: Barry Lind
Date:
Subject: Re: j2sdk1.4.0 jdbc compile errors