trunk/sql/zz_dst_files_fix.sql

select hostid,shareid,num,abstime(date),size,inc_size into dst_files from backups where date > abstime('2005-10-24')::int order by abstime,hostid,num;

delete from backups where date > abstime('2005-10-24')::int;
vacuum analyze backups;

create index dst_i1 on dst_files(shareid) ;
create index dst_i2 on dst_files(num) ;
vacuum analyze dst_files ;
create index dst_i3 on files(backupnum) ;
vacuum analyze files ;

select id into dst_files_ids from files inner join dst_files on dst_files.shareid = files.shareid and dst_files.num = files.backupnum ;
create unique index dst_i4 on dst_files_ids(id) ;
vacuum analyze dst_files_ids ;

delete from files where id in (select id from dst_files_ids) ;

vacuum full analyze verbose files ;

drop table dst_files_ids ;
drop table dst_files ;

drop index dst_i3 ;
1	select hostid,shareid,num,abstime(date),size,inc_size into dst_files from backups where date > abstime('2005-10-24')::int order by abstime,hostid,num;
2
3	delete from backups where date > abstime('2005-10-24')::int;
4	vacuum analyze backups;
5
6	create index dst_i1 on dst_files(shareid) ;
7	create index dst_i2 on dst_files(num) ;
8	vacuum analyze dst_files ;
9	create index dst_i3 on files(backupnum) ;
10	vacuum analyze files ;
11
12	select id into dst_files_ids from files inner join dst_files on dst_files.shareid = files.shareid and dst_files.num = files.backupnum ;
13	create unique index dst_i4 on dst_files_ids(id) ;
14	vacuum analyze dst_files_ids ;
15
16	delete from files where id in (select id from dst_files_ids) ;
17
18	vacuum full analyze verbose files ;
19
20	drop table dst_files_ids ;
21	drop table dst_files ;
22
23	drop index dst_i3 ;