3 ms·

Repeat after me: set work_mem to 'XXXGB'; set maintenance_work_mem to 'YYYGB'; swing away!

• kibibu 13y ago
  This annoys me so much about PostgreSQL. Why not have useful defaults?!
  • ilikepi 13y ago
    The defaults are useful in that they reflect a configuration that is appropriate to get the system running on a large variety of hardware. It's not really the responsibility of the Pg developers to guess at the "best" settings for any specific environment, because environments and configurations vary greatly.
    • jedberg 13y ago
      I agree to a point, but it would be nice if there were some provided default configs for various classes of machines. Especially defaults for the most popular EC2 instance types.
      • VLM 13y ago
        Its two dimensional because of "various classes of applications"
• rgbrenner 13y ago
  work_mem is a per-sort setting. So if you have 20 users connected, running a single query with 4 sorts each, that's 80 x work_mem. If it's set to GB anything, that's going to get out of hand very fast. I recommend this guide.. it's a good start: http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serve...
• wfn 13y ago
  More like, "set shared_buffers", "set effective_cache_size".. Also, seconding rgbrenner re: "Tuning your PostgreSQL server" article.