Re: [Cert] Online or paperwork - results

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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD