pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Martin Nickel <martin@portant.com>
To: pgsql-performance@postgresql.org
Subject: Re: Sequential scan on FK join
Date: Fri, 21 Oct 2005 03:51:56 -0500
Message-ID: <pan.2005.10.21.08.51.54.741707@portant.com> (raw)
References: <pan.2005.10.12.20.40.22.703085@portant.com>
	<4353648C.8040507@archonet.com>
	<pan.2005.10.17.13.07.53.915839@portant.com>
	<4353E342.2060708@archonet.com>
	<pan.2005.10.17.19.56.36.629275@portant.com>
	<4354A9AF.30300@archonet.com>

On Tue, 18 Oct 2005 08:52:15 +0100, Richard Huxton wrote:
>   3. Actually - are you happy that your general configuration is OK? 
We're running dual Opteron 244s with 4G of memory.  The platform is
Suse 9.3, 64 bit.  The database is on a 3ware 9500S-8 sata raid controller
configured raid 10 with 4 drives plus a hot swap.  Drives are
7400 rpm (don't remember model or size).

I'm running Postgres 8.0.3.  Here are some of the relevant conf file
parameters:
shared_buffers = 50000
sort_mem = 8192
work_mem = 256000
vacuum_mem = 32768
max_fsm_pages = 40000
max_fsm_relations = 1000

I realize shared_buffers is too high.  Not sure on the others.  Thanks for
any help you can suggest.  I've moved most of these around some and
restarted without any clear changes for the better or worse (just
seat-of-the-pants feel - I haven't tried to benchmark the result of
changes at all).

Thanks,
Martin





view thread (9+ messages)  latest in thread

Message-ID: <pan.2005.10.21.08.51.54.741707@portant.com>
Permalink:  ../pan.2005.10.21.08.51.54.741707@portant.com/
Also on:    postgresql.org/message-id/pan.2005.10.21.08.51.54.741707@portant.com

 · 

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: martin@portant.com
  Subject: Re: Sequential scan on FK join
  In-Reply-To: <pan.2005.10.21.08.51.54.741707@portant.com>

* 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