Skip site navigation (1) Skip section navigation (2)

Re: [Cert] Online or paperwork - results

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: cert(at)lists(dot)postgresqlcertification(dot)org, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [Cert] Online or paperwork - results
Date: 2008-06-13 02:33:43
Message-ID: 1213324423.11470.221.camel@jd-laptop (view raw or flat)
Thread:
Lists: pgsql-advocacy

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



In response to

pgsql-advocacy by date

Next:From: Joshua D. DrakeDate: 2008-06-13 02:36:07
Subject: Re: PostgreSQL derivatives
Previous:From: Bruce MomjianDate: 2008-06-13 02:31:18
Subject: Re: PostgreSQL derivatives

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group