From: Simon Waters <simonw@zynet.net>
To: pgsql-performance@postgresql.org
Subject: Re: understanding postgres issues/bottlenecks
Date: Wed, 7 Jan 2009 09:31:25 +0000
Message-ID: <200901070931.26788.simonw@zynet.net> (raw)
In-Reply-To: <49642CC6.4020902@cesmail.net>
References: <49638BE9.2030701@gmail.com>
<72dbd3150901061533o5f8601cau389ceaf0ad6840cd@mail.gmail.com>
<49642CC6.4020902@cesmail.net>
On Wednesday 07 January 2009 04:17:10 M. Edward (Ed) Borasky wrote:
>
> 1. The package it lives in is called "sysstat". Most Linux distros do
> *not* install "sysstat" by default. Somebody should beat up on them
> about that. :)
Hehe, although sysstat and friends did have issues on Linux for a long time.
Nothing worse than misleading stats, so I suspect it lost a lot of friends
back then. It is a lot better these days when most of the "Unix" software
targets Linux first, and other kernels second.
Aside from all the advice here about system tuning, as a system admin I'd also
ask is the box doing the job you need? And are you looking at the Postgres
log (with logging of slow queries) to see that queries perform in a sensible
time? I'd assume with the current performance figure there is an issue
somewhere, but I've been to places where it was as simple as adding one
index, or even modifying an index so it does what the application developer
intended instead of what they ask for ;)
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: simonw@zynet.net
Subject: Re: understanding postgres issues/bottlenecks
In-Reply-To: <200901070931.26788.simonw@zynet.net>
* 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