Re: [Cert] Online or paperwork - results
От | Joshua D. Drake |
---|---|
Тема | Re: [Cert] Online or paperwork - results |
Дата | |
Msg-id | 1213324423.11470.221.camel@jd-laptop обсуждение исходный текст |
Ответ на | Re: [Cert] Online or paperwork - results ("Greg Sabino Mullane" <greg@turnstep.com>) |
Список | pgsql-advocacy |
On Fri, 2008-06-13 at 01:39 +0000, Greg Sabino Mullane wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: RIPEMD160 > 1) What value between 99 and 101 should you set default_statistics_target to? > 100 > 2) Your queries are running slow, what do you do? > > A) Set random_page_cost = 1 and geqo_threshold = 2; > B) Do an ALTER TABLE SET TYPE=MYISAM; for each table in your database > C) Blame it on the application! > D) rm -fr the pg_xlog directory to remove those annoying WAL files > E) Demand better hardware (and an iPhone) > F) Run vacuum full and reindex database as a cronjob every 5 minutes > A & E, oh and make sure you actually vacuum analyze. > 3) Your database just got erased, and you need a new one. You reach for: > > A) Your shiny Postgres CD > B) Your snazzy Postgres thumb drive > C) Your lovely Postgres sticker collection > D) Your resume, to make sure it is up to date E) Call Command PRompt > > 4) The best way to edit the postgresql.conf file is with: > (wrong answers will be asked to leave the room immediately) > > A) emacs > B) xemacs > C) vi > D) vim > E) elvis F) Joe > > 5) MySQL has a billion dollars, is installed everywhere, has pluggable > engines, a mountain of books, great press, lots of smart Sun developers, > and tons of web 2.0 companies behind it. Postgres has Tom Lane. > How do we level the playing field? > > A) Ask Tom to take every other week off. > B) Have him write a MySQL engine that works. > C) Make him submit all patches in Klingon as mp3s. > A) Joshua D. Drake
В списке pgsql-advocacy по дате отправления: