Re: how much mem to give postgres? - Mailing list pgsql-performance

From Tom Lane
Subject Re: how much mem to give postgres?
Date
Msg-id 29976.1098246931@sss.pgh.pa.us
Whole thread Raw
In response to how much mem to give postgres?  (Josh Close <narshe@gmail.com>)
Responses Re: how much mem to give postgres?  (Josh Close <narshe@gmail.com>)
List pgsql-performance
Josh Close <narshe@gmail.com> writes:
> I'm trying to figure out what I need to do to get my postgres server
> moving faster. It's just crawling right now.

I suspect that fooling with shared_buffers is entirely the wrong tree
for you to be barking up.  My suggestion is to be looking at individual
queries that are slow, and seeing how to speed those up.  This might
involve adding indexes, or tweaking the query source, or adjusting
planner parameters, or several other things.  EXPLAIN ANALYZE is your
friend ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Josh Close
Date:
Subject: Re: how much mem to give postgres?
Next
From: Josh Berkus
Date:
Subject: Re: how much mem to give postgres?