Search Postgresql Archives

Re: MySQL versus Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx   www.2ndQuadrant.us


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux