From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Martin Nickel <martin@portant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Sequential scan on FK join
Date: Sat, 22 Oct 2005 10:25:12 -0300
Message-ID: <20051022132512.GE18064@surnet.cl> (raw)
In-Reply-To: <pan.2005.10.21.08.51.54.741707@portant.com>
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>
<pan.2005.10.21.08.51.54.741707@portant.com>
Martin Nickel wrote:
> 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
Interesting that you set both sort_mem and work_mem. Do you realize
that the former is an obsolete name, and currently a synonym for the
latter? Maybe the problem is that you are using too much memory for
sorts, forcing swap usage, etc.
--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J
"La persona que no quería pecar / estaba obligada a sentarse
en duras y empinadas sillas / desprovistas, por cierto
de blandos atenuantes" (Patricio Vogel)
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: alvherre@alvh.no-ip.org, martin@portant.com
Subject: Re: Sequential scan on FK join
In-Reply-To: <20051022132512.GE18064@surnet.cl>
* 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