Re: MySQL versus Postgres

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: MySQL versus Postgres
Дата
Msg-id 4C638972.20608@2ndquadrant.com
обсуждение исходный текст
Ответ на MySQL versus Postgres  (John Gage <jsmgage@numericable.fr>)
Ответы Re: MySQL versus Postgres  (Scott Marlowe <scott.marlowe@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: deadlock
Следующее
От: Sandeep Srinivasa
Дата:
Сообщение: Re: MySQL versus Postgres