From: Claus Guttesen <kometen@gmail.com>
To: Guillaume Smet <guillaume.smet@openwide.fr>
Cc: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: weird performances problem
Date: Fri, 18 Nov 2005 01:15:28 +0100
Message-ID: <b41c75520511171615g7c0fe923l@mail.gmail.com> (raw)
In-Reply-To: <437D13AA.4010309@openwide.fr>
References: <437CC21D.8070402@openwide.fr>
<20051117221314.GC26696@phlogiston.dyndns.org>
<437D13AA.4010309@openwide.fr>
> I forgot to give our non default postgresql.conf parameters:
> shared_buffers = 28800
> sort_mem = 32768
> vacuum_mem = 32768
> max_fsm_pages = 350000
> max_fsm_relations = 2000
> checkpoint_segments = 16
> effective_cache_size = 270000
> random_page_cost = 2
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.
What OS are you running?
regards
Claus
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: kometen@gmail.com, guillaume.smet@openwide.fr, ajs@crankycanuck.ca
Subject: Re: weird performances problem
In-Reply-To: <b41c75520511171615g7c0fe923l@mail.gmail.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