From: Guillaume Smet <guillaume.smet@openwide.fr>
To: Claus Guttesen <kometen@gmail.com>
Cc: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: weird performances problem
Date: Tue, 22 Nov 2005 15:37:52 +0100
Message-ID: <43832D40.7020309@openwide.fr> (raw)
In-Reply-To: <b41c75520511171615g7c0fe923l@mail.gmail.com>
References: <437CC21D.8070402@openwide.fr>
<20051117221314.GC26696@phlogiston.dyndns.org>
<437D13AA.4010309@openwide.fr>
<b41c75520511171615g7c0fe923l@mail.gmail.com>
Claus and Andrew,
Claus Guttesen wrote:
> Isn't sort_mem quite high? Remember that sort_mem size is allocated
> for each sort, not for each connection. Mine is 4096 (4 MB). My
> effective_cache_size is set to 27462.
I tested sort mem from 4096 to 32768 (4096, 8192, 16384, 32768) this
afternoon and 32768 is definitely the best value for us. We still have
free memory using it, we don't have any swap and queries are generally
faster (I log all queries taking more than 500ms and the log is growing
far faster with lower values of sort_mem).
> What OS are you running?
# cat /etc/redhat-release
CentOS release 3.6 (Final)
so it's a RHEL 3 upd 6.
# uname -a
Linux our.host 2.4.21-37.ELsmp #1 SMP Wed Sep 28 14:05:46 EDT 2005 i686
i686 i386 GNU/Linux
# cat /proc/cpuinfo
4x
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) MP CPU 2.20GHz
stepping : 6
cpu MHz : 2192.976
cache size : 512 KB
# cat /proc/meminfo
total: used: free: shared: buffers: cached:
Mem: 3949797376 3478376448 471420928 0 83410944 2679156736
Swap: 4384022528 9797632 4374224896
MemTotal: 3857224 kB
MemFree: 460372 kB
MemShared: 0 kB
Buffers: 81456 kB
Cached: 2610764 kB
HTH
Regards,
--
Guillaume
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: guillaume.smet@openwide.fr, kometen@gmail.com, ajs@crankycanuck.ca
Subject: Re: weird performances problem
In-Reply-To: <43832D40.7020309@openwide.fr>
* 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