Alvaro, On 11/2/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Even though the restore times are very similar, I find it a bit > disturbing that the "CREATE INDEX" is shown to be waiting. Was it just > bad luck that the ps output shows it that way, or does it really wait > for long?
I did the test again with the reference database I used a month ago. My previous figures with 8.3devel of October 1st were: - autovacuum off: 14m39 - autovacuum on, delay 20: 51m37 With 8.3devel of today, I have: - autovacuum on, delay 20: 15m26 I can see (CREATE INDEX|ALTER TABLE) waiting from time to time in my watch -n 1 but it disappears within 1 or 2 seconds so what Simon and you did seems to work as expected AFAICS. -- Guillaume ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings