Henner,

[snip]

> Maybe you have an idea: I need something like the truncate command in
> Oracle.
> 1. Have a table with 2.500.000 records.
> 2. Remove all records from this table.
> 3. Insert 4.500.000 records again.
>
> After this procedure the database grows for 400 MB.
>
> This will happen once a week. My first approach for this problem is to
> make backup restore cycle to compress data and force a GC.
>
> There the problem starts...

instead of deleting all records you could try to drop the table, rebuild
it and then insert the 4.500.000 records.

Does that make a difference?

Robert