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: