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 3CBDB992.4060508@openratings.com
Whole thread Raw
In response to Re: Large table update/vacuum PLEASE HELP!  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Large table update/vacuum PLEASE HELP!
List pgsql-general
>
>
>
>In the 10% case, you should be within the realm where the table's steady
>state size is around that much more with reasonable frequency normal
>VACUUMs and an appropriately sized free space map.
>
Are you saying that, if I, say, update 1000 tuples today, and another
1000 tomorow, it will reuse the today's dead tuples, and not create new
ones, so that I end up with just 1000 of them, not 2000?

Just making sure...

Thanks a lot!

Dima



pgsql-general by date:

Previous
From: noy
Date:
Subject: Re: Date precision problem
Next
From: Matthew Stanfield
Date:
Subject: Re: Incorrect password using pg_ctl