From: Kevin Grittner <kgrittn@mail.com>
To: Shams Khan <shams.khan22@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level
Date: Mon, 17 Dec 2012 08:08:31 -0500
Message-ID: <20121217130831.14720@gmx.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Shams Khan wrote:
> Question 1. How do we correlate our memory with kernel parameters, I mean
> to say is there any connection between shared_buffer and kernel SHMMAX. For
> example if I define my shared buffer more than my current SHMMAX value, it
> would not allow me to use that ??or vice versa. Please throw some light.
If SHMMAX is not large enough to allow the PostgreSQL service to
acquire the amount of shared memory it needs based on your
configuration settings, the PostgreSQL server will log an error and
fail to start. Please see the docs for more information:
http://www.postgresql.org/docs/current/static/kernel-resources.html> Questions 2. I want to show the last result of last query before and after
> changing the parameters, I found performance was degraded.
> Total runtime: 142.812 ms
> Total runtime: 145.127 ms
The plan didn't change and the times were different by less than
2%. There can easily be that much variation from one run to the
next. If you try the same query many times (say, 10 or more) with
each configuration and it is consistently faster with one than the
other, then you will have pretty good evidence which configuration
is better for that particular query. If the same configuration wins
in general, use it.
Since performance differences which are that small are often caused
by very obscure issues, it can be very difficult to pin down the
reason. It's generally not anything to fret over.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: kgrittn@mail.com, shams.khan22@gmail.com
Subject: Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level
In-Reply-To: <20121217130831.14720@gmx.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