Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Advocacy > Re: [Cert] Onli...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 1479 of 1551
Post > Topic >>

Re: [Cert] Online or paperwork - results

by greg@[EMAIL PROTECTED] ("Greg Sabino Mullane") Jun 13, 2008 at 01:39 AM

-----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 ****ny 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@[EMAIL PROTECTED]
 Key: 0x14964AC8 200806122134
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

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



-- 
Sent via pgsql-advocacy mailing list (pgsql-advocacy@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
 




 5 Posts in Topic:
Re: [Cert] Online or paperwork - results
greg@[EMAIL PROTECTED] (  2008-06-13 01:39:43 
Re: [Cert] Online or paperwork - results
jd@[EMAIL PROTECTED] (&q  2008-06-12 19:33:43 
Re: [Cert] Online or paperwork - results
gsmith@[EMAIL PROTECTED]   2008-06-12 23:09:08 
Re: [Cert] Online or paperwork - results
jd@[EMAIL PROTECTED] (&q  2008-06-12 20:49:44 
Re: [Cert] Online or paperwork - results
jd@[EMAIL PROTECTED] (&q  2008-06-13 08:37:39 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 11:18:30 CST 2008.