Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id B712DB5DBC8
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Thu, 16 Jun 2011 15:13:28 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 93464-02
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Thu, 16 Jun 2011 18:13:22 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-qw0-f46.google.com (mail-qw0-f46.google.com
	[209.85.216.46])
	by mail.postgresql.org (Postfix) with ESMTP id 6C314B5DBC0
	for <pgsql-hackers@postgresql.org>;
	Thu, 16 Jun 2011 15:13:22 -0300 (ADT)
Received: by qwk3 with SMTP id 3so805206qwk.19
	for <pgsql-hackers@postgresql.org>;
	Thu, 16 Jun 2011 11:13:22 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:in-reply-to:references:from:date
	:message-id:subject:to:cc:content-type;
	bh=gO94g/YVphAa3odN+V6SgZiNt8W5OnK8ujOfiy+A8vg=;
	b=oEUe3Cj6gg7evlUXNB9JuhjKwGWXIaja1lWvAEn7+mEluhEbW8fjCr/IxCJuOsobRq
	FkF4P9Csh9dvWvuxZc8FladAkhZpDg6qGN7U+HxjJzOnGiPIklRujqLcc7i2uz4LKF4X
	krSPHoOPBnscZ5EFNVOax8cW9V0jgv/Ea+Ugk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:from:date:message-id:subject:to
	:cc:content-type;
	b=YDUf7la/Etnn6P+UFAB5skxWJTtY6qLzCUs53WPgDpuazGEQ4G2HXUEsa0nM+kK8R4
	In6uzco0l3GG7GjX9UIYozd72owJJ5DxMxWQymSM74gvxZTkzitsUQpEAU6TpWZsTz76
	LebvuZcxTJRQyw2nTGiVBehnpmBIGLoBWp/FA=
Received: by 10.229.10.131 with SMTP id p3mr1009626qcp.166.1308248002067; Thu,
	16 Jun 2011 11:13:22 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.229.247.140 with HTTP; Thu, 16 Jun 2011 11:13:02 -0700 (PDT)
In-Reply-To: <BANLkTi=x0Ck1z_NbkqeqvuKXs9kHOR+5WQ@mail.gmail.com>
References: <BANLkTikgOQ1+r=A9b08szNTeEWsk-cNMMg@mail.gmail.com>
	<4DEC84D7.7040602@enterprisedb.com> <4DECB141.2040707@enterprisedb.com>
	<BANLkTimDQewwaumOaDtFjSb+2edn-E_dNg@mail.gmail.com>
	<BANLkTimoH+8tsm6LG1jjFNY7xiFXHeNDDA@mail.gmail.com>
	<BANLkTinWE4DX41=eXnX+YWqFXZ_xJqOC8w@mail.gmail.com>
	<BANLkTinMB-GSjFDThc0o9hRWa+_dJJXPZg@mail.gmail.com>
	<4DF8676F.9040801@enterprisedb.com>
	<BANLkTimr___BFy+98t36tkbUvvavUzjV9A@mail.gmail.com>
	<BANLkTi=x0Ck1z_NbkqeqvuKXs9kHOR+5WQ@mail.gmail.com>
From: Alexander Korotkov <aekorotkov@gmail.com>
Date: Thu, 16 Jun 2011 22:13:02 +0400
Message-ID: <BANLkTikP6RAYmUriquQEdKjEBviTH2vWRQ@mail.gmail.com>
Subject: Re: WIP: Fast GiST index build
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary=00151757468470fda904a5d83928
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.897 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RFC_ABUSE_POST=0.001
X-Spam-Level: 
X-Archive-Number: 201106/1430
X-Sequence-Number: 190143

--00151757468470fda904a5d83928
Content-Type: text/plain; charset=ISO-8859-1

My current idea is to measure number of IO accesses by pg_stat_statements
and measure CPU usage by /proc/PID/stat. Any thoughts?

------
With best regards,
Alexander Korotkov.


On Thu, Jun 16, 2011 at 1:33 PM, Alexander Korotkov <aekorotkov@gmail.com>wrote:

> Actually, I would like to measure CPU and IO load independently for more
> comprehensive benchmarks. Can you advice me some appropriate tools for it?
>
> ------
> With best regards,
> Alexander Korotkov.
>

--00151757468470fda904a5d83928
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

My current idea is to measure number of IO accesses by pg_stat_statements a=
nd measure CPU usage by /proc/PID/stat. Any thoughts?<br clear=3D"all"><met=
a http-equiv=3D"content-type" content=3D"text/html; charset=3Dutf-8"><br><d=
iv>------<br>

With best regards,<br>Alexander Korotkov. =A0<br>
<br><br><div class=3D"gmail_quote">On Thu, Jun 16, 2011 at 1:33 PM, Alexand=
er Korotkov <span dir=3D"ltr">&lt;<a href=3D"mailto:aekorotkov@gmail.com">a=
ekorotkov@gmail.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quo=
te" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;=
">

<div>Actually, I would like to measure CPU and IO load independently for mo=
re comprehensive benchmarks. Can you advice me some appropriate tools for i=
t?</div><div><div></div><div class=3D"h5">
<div><br></div>------<br>With best regards,<br>Alexander Korotkov. =A0<br>
</div></div></blockquote></div><br></div>

--00151757468470fda904a5d83928--