X-Original-To: pgsql-benchmarks-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5A2BB32B0E9; Mon, 11 Oct 2004 16:39:12 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65553-01; Mon, 11 Oct 2004 15:39:06 +0000 (GMT) Received: from mailer.unicite.fr.netcentrex.net (unknown [62.161.167.249]) by svr1.postgresql.org (Postfix) with ESMTP id 324A132AA59; Mon, 11 Oct 2004 16:39:04 +0100 (BST) Received: from [192.168.101.228] ([192.168.101.228]) by mailer.unicite.fr.netcentrex.net with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id 42CX0WPL; Mon, 11 Oct 2004 17:39:02 +0200 Message-ID: <416AA915.1000008@fr.netcentrex.net> Date: Mon, 11 Oct 2004 17:39:01 +0200 From: =?ISO-8859-1?Q?=22Alban_M=E9dici_=28NetCentrex=29=22?= User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-benchmarks@postgresql.org Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] stats on cursor and query execution References: <4163C5C3.3030304@fr.netcentrex.net> <25576.1097072199@sss.pgh.pa.us> <4166542E.2020809@fr.netcentrex.net> <11894.1097243756@sss.pgh.pa.us> In-Reply-To: <11894.1097243756@sss.pgh.pa.us> Content-Type: multipart/alternative; boundary="------------060000070001090402020807" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200410/5 X-Sequence-Number: 22 This is a multi-part message in MIME format. --------------060000070001090402020807 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Ok thanks tom, what shall we do without U ? by the way I have look at my kernel and getrusage() is well configure=20 and return good results. i/o stats too. I test an other version of postgresql and now, it works fine. It' seems to be an install bug. thx regards, Alban M=E9dici on 08/10/2004 15:55 Tom Lane said the following: >=3D?ISO-8859-1?Q?=3D22Alban_M=3DE9dici_=3D28NetCentrex=3D29=3D22?=3D writes: >=20=20 > >>Thanks for your repply, but I still don"t understand why the statistic >>logs : >>! 0/0 [0/0] filesystem blocks in/out >>it told me there is no hard disk access, I'm sure there is, >>=20=20=20=20 >> > >Complain to your friendly local kernel hacker. We just report what >getrusage() tells us; so if the number is wrong then it's a kernel bug. > > regards, tom lane > >=20=20 > --=20 Alban M=E9dici R&D software engineer ------------------------------ you can contact me @ : IPPhone : +33 (0)2 31 46 37 68 alban.medici@fr.netcentrex.net http://www.netcentrex.net ------------------------------ --------------060000070001090402020807 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Ok thanks tom, what shall we do without U ?

by the way I have look at my kernel and getrusage() is well configure and return good results.
i/o stats too.

I test an other version of postgresql and now, it works fine.
It' seems to be an install bug.

thx
regards, Alban Médici


on 08/10/2004 15:55 Tom Lane said the following:
=?ISO-8859-1?Q?=22Alban_M=E9dici_=28NetCentrex=29=22?= <amedici@fr.netcentrex.net> writes:
  
Thanks for your repply,  but I still don"t understand why the statistic
logs   :
!       0/0 [0/0] filesystem blocks in/out
it told me there is no hard disk access, I'm sure there is,
    

Complain to your friendly local kernel hacker.  We just report what
getrusage() tells us; so if the number is wrong then it's a kernel bug.

			regards, tom lane

  

-- 
Alban Médici
R&D software engineer
------------------------------
you can contact me @ :
IPPhone : +33 (0)2 31 46 37 68
alban.medici@fr.netcentrex.net
http://www.netcentrex.net
------------------------------
--------------060000070001090402020807--