Re: Making the most of memory?

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Joshua Fielek" <jfielek(at)centriccrm(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Making the most of memory?
Date: 2008-01-24 18:21:21
Message-ID: b42b73150801241021o67ee36e6r870fab8b1e47eb4a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Jan 24, 2008 1:01 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> > I'll
give you a little hint about postgresql.conf...tuning shared
> buffers rarely has a huge impact on performance...the o/s will

oops. i meant to say the o/s will cache the files just fine...the
setting that _does_ affect query performance is work_mem, but this
applies to queries on a case by case basis.

merlin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2008-01-24 18:49:34 Re: Postgres 8.2 memory weirdness
Previous Message Merlin Moncure 2008-01-24 18:01:33 Re: Making the most of memory?