[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: UDD migration to ullmann.debian.org

On Mon, 25 Jun 2012, Lucas Nussbaum wrote:

> [dsa] tune PG (with pgtune?)
>   Benchmark 1: (squeeze-security import)
>   udd@ullmann:/srv/udd.debian.org/udd$ time ./update-and-run.sh debian-squeeze-security
>   ullmann: real	0m55.363s user	0m10.285s sys	0m0.476s
>   my laptop (with SSD): real	0m17.079s user	0m9.229s sys	0m0.196s
>   samosa: real	9m48.011s user	0m26.834s sys	0m1.116s
>   Benchmark 2: (bugs import)
>   udd@ullmann:/srv/udd.debian.org/udd$ time ./update-and-run.sh bugs
>   ullmann: real	33m12.664s user	26m44.580s sys	1m31.834s
>   my laptop (with SSD): real	17m37.500s user	16m4.344s sys	0m25.270s
>   samosa: hours
>   (the numbers for samosa are particularly bad, but that could be because 
>   the cron'ed manual vacuuming happens at the beginning of each month)

Since importing depends on other hosts, it's not too representative.
You should probably benchmark queries, not imports.

                           |  .''`.       ** Debian **
      Peter Palfrader      | : :' :      The  universal
 http://www.palfrader.org/ | `. `'      Operating System
                           |   `-    http://www.debian.org/

Reply to: