Re: [Cert] Online or paperwork - results

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