Re: Large table update/vacuum PLEASE HELP!

From: Dmitry Tkach <dmitry(at)openratings(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>, pgsql-general(at)postgresql(dot)org
Subject: Re: Large table update/vacuum PLEASE HELP!
Date: 2002-04-17 18:28:06
Message-ID: 3CBDBEB6.1070906@openratings.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Barry Lind 2002-04-17 18:51:02 Re: j2sdk1.4.0 jdbc compile errors
Previous Message nandrats 2002-04-17 18:26:42 C++ and Postgres