Re: Database growing. Need autovacuum help.

On Tue, Jun 3, 2008 at 7:41 AM, Henrik <henke@mac.se> wrote:
>
> To be able to handle versions we always insert new folders even though
> nothing has changed but it seemd like the best way to do it.
>
> E.g
>
> First run:
>        tbl_file 500k new files.
>        tbl_folder 50k new rows.
>        tbl_file_folder 550k new rows.
>
> Second run with no new files.
>        tbl_file unchanged.
>        tbl_folder 50k new rows
>        tbl_file_folder 550k new rows.

On useful trick is to include a where clause that prevents the extra updates.

I.e. update table set field=123 where field <> 123;