> 1. Are you using transactions?
> 2. Do you have an index on id?
Hi,
Thanks for answering...
1. I tried with and without transctions : same result. In the
tests I make right now, I have disable transactions.
2. yes, a unique index.
Each time I run a "VACUUM FULL", the process is very fast
again for 6-7 times (10-15s). After that, it takes again
about 2-3 minutes...
When I only run a "VACUUM" (not FULL), it doesn't make any difference.
--
Xavier Bugaud