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/


-- 
To UNSUBSCRIBE, email to debian-qa-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/20120626074648.gw13...@anguilla.noreply.org

Reply via email to