Thread: Re: [Cert] Online or paperwork - results

Re: [Cert] Online or paperwork - results

From
"Greg Sabino Mullane"
Date:
-----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-----



Re: [Cert] Online or paperwork - results

From
"Joshua D. Drake"
Date:

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



Re: [Cert] Online or paperwork - results

From
Greg Smith
Date:
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

Re: [Cert] Online or paperwork - results

From
"Joshua D. Drake"
Date:

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
>


Re: [Cert] Online or paperwork - results

From
"Joshua D. Drake"
Date:

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
>