On 9/22/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Please try that experiment with all three configurations on both
> versions:
> * autovacuum off
> * autovacuum on, autovacuum_vacuum_cost_delay = 0
> * autovacuum on, autovacuum_vacuum_cost_delay = 20
I've finally found some time to spend on these tests. Here are the results:
* 8.2.5 *
- autovacuum off + ANALYZE: less than 16 minutes (figures previously
posted in this thread) - default configuration of 8.2
- autovacuum on, delay 0: 16m29
- autovacuum on, delay 20: 16m13
(I didn't repeat the run but we can see that autovacuum doesn't
introduce too much slowdown during the restore operation)
* 8.3devel freshly compiled *
- autovacuum off: 14m39
- autovacuum on, delay 0: 15m32
- autovacuum on, delay 20: 51m37 (the box is idle during a large
amount of this time) - default configuration of 8.3devel
--
Guillaume
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
