pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Josh Close <narshe@gmail.com>
Cc: POSTGRES-PERFORMANCE <pgsql-performance@postgresql.org>
Subject: Re: how much mem to give postgres?
Date: Wed, 20 Oct 2004 00:35:31 -0400
Message-ID: <29976.1098246931@sss.pgh.pa.us> (raw)
In-Reply-To: <4a0cafe2041019153133f854e9@mail.gmail.com>
References: <4a0cafe2041019153133f854e9@mail.gmail.com>

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



view thread (11+ messages)  latest in thread

Message-ID: <29976.1098246931@sss.pgh.pa.us>
Permalink:  ../29976.1098246931@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/29976.1098246931@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, narshe@gmail.com
  Subject: Re: how much mem to give postgres?
  In-Reply-To: <29976.1098246931@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox