Re: Database growing. Need autovacuum help.

3 jun 2008 kl. 16.06 skrev Scott Marlowe:

> On Tue, Jun 3, 2008 at 7:41 AM, Henrik <henke(at)mac(dot)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;

Mmm I keep that in mind. The problem is that on these tables I only do
INSERTS and DELETES. :)

Maybe I can redesign it but I can find a good way...yet...

Thanks!