Re: MySQL versus Postgres

Sandeep Srinivasa wrote:
>  Maybe a tabular form would be nice - "work_mem" under...

The problem with work_mem in particular is that the useful range depends
quite a bit on how complicated you expect the average query running to
be.  pgtune tries to model this using an input of what type of
application you're running; presuming that a data warehouse application
is far more likely to sort/hash a lot of data in one query than a web
application for example.  But even that relatively simple idea has
proven to be confusing to a lot of people, based on the feedback I've
gotten.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us