Re: MySQL versus Postgres - Mailing list pgsql-general

From Greg Smith
Subject Re: MySQL versus Postgres
Date
Msg-id 4C638972.20608@2ndquadrant.com
Whole thread Raw
In response to MySQL versus Postgres  (John Gage <jsmgage@numericable.fr>)
Responses Re: MySQL versus Postgres
List pgsql-general
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


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: deadlock
Next
From: Sandeep Srinivasa
Date:
Subject: Re: MySQL versus Postgres