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