Re: Shared_buffers and kernel parameters, tuning

From: Jonathan Gardner <jgardner(at)jonathangardner(dot)net>
To: "Lending, Rune" <rune(dot)lending(at)inpoc(dot)com>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Shared_buffers and kernel parameters, tuning
Date: 2003-06-06 21:36:18
Message-ID: 200306061436.19798.jgardner@jonathangardner.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thursday 05 June 2003 01:10, Lending, Rune wrote:
> It is very difficult to test
> the actual performance since there is a hugh difference in traffic on dev
> and prod.

I would resolve this problem as well. How can you know any of your changes
won't cause severe problems?

Using your favorite scripting language, and your knowledge of what statements
are being executed, you should devise some test processes that mimic the
statements being run on production. Then, have a computer (or several, if
need be) launch a whole bunch of processes that run these statements against
the dev server. It isn't too hard to generate appropriate traffic on the dev
server. And you will be very pleased with the ability to experiment with more
load and various settings. Plus, you can measure how long each statement
takes to run, and track how indexes and variations on statements will affect
performance.

I think this is fundamental to any performance tweaks. If you have no way to
control the traffic to the server, and you have no way of measuring the
performance, how can you tell if what you did helped or hurt?

- --
Jonathan Gardner <jgardner(at)jonathangardner(dot)net>
(was jgardn(at)alumni(dot)washington(dot)edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+4QlSWgwF3QvpWNwRApJxAKC1XU/h2ypAcCf0ewJU+xuD14powQCgqMOT
LKUWPrHPEugf5r7C+kP3eSM=
=XkNs
-----END PGP SIGNATURE-----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jonathan Gardner 2003-06-06 21:38:00 Re: No acceptable C compiler found
Previous Message Jonathan Gardner 2003-06-06 21:11:21 Re: Urgent: Restoring many schemas in a database