Thread: Re: [Cert] Online or paperwork - results
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > Not only first, we of course need this modules. > I will start a discussion about this topic in the next days, but that's > a different thread. All this talk about process, what we need are some exam questions. Here's some off the top of my head: 1) What value between 99 and 101 should you set default_statistics_target to? 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 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 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 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. - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200806122134 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAkhRz2QACgkQvJuQZxSWSsiyHgCgn5k+XEG91cvlwWQGVTvT35sp zLkAnRiaSVkqpLgKmtKhx7Yd7AcxbxvY =Y1Of -----END PGP SIGNATURE-----
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
On Fri, 13 Jun 2008, Greg Sabino Mullane wrote: > 1) What value between 99 and 101 should you set default_statistics_target to? 1000 unless you have some little toy database; why fool around? > 2) Your queries are running slow, what do you do? Blame the storage vendor. > 3) Your database just got erased, and you need a new one. You reach for: A scapegoat. > 4) The best way to edit the postgresql.conf file is with: sed > 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? Barrage the lists with people demanding optimizer hints. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
On Thu, 2008-06-12 at 23:09 -0400, Greg Smith wrote: > On Fri, 13 Jun 2008, Greg Sabino Mullane wrote: > > 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? > > Barrage the lists with people demanding optimizer hints. packages > > -- > * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD >
On Thu, 2008-06-12 at 21:35 -0700, Colin Wetherbee wrote: > Greg Sabino Mullane wrote: > > All this talk about process, what we need are some exam questions. > > Here's some off the top of my head: > D. Obviously. > > > 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. > > D) Invite Tom to a summer resort in the Swiss Alps, complete with a > MySQL-dev kickboxing class. > I think Tom is more the kind of person that would say, "Ahh Grass hopper, when you can take this pebble from my hand, you shall be ready to take the MySQL-dev kickboxing class" > Colin > _______________________________________________ > Cert mailing list > Cert@lists.postgresqlcertification.org > http://lists.postgresqlcertification.org/mailman/listinfo/cert >