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