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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200806122134
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkhRz2QACgkQvJuQZxSWSsiyHgCgn5k+XEG91cvlwWQGVTvT35sp
zLkAnRiaSVkqpLgKmtKhx7Yd7AcxbxvY
=Y1Of
-----END PGP SIGNATURE-----