Skip site navigation (1) Skip section navigation (2)

Re: EXPLAIN ANALYZE printing logical and hardware I/O per-node

From: Decibel! <decibel(at)decibel(dot)org>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: "Neil Conway" <neilc(at)samurai(dot)com>, "pgsql-hackers list" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: EXPLAIN ANALYZE printing logical and hardware I/O per-node
Date: 2007-12-19 01:17:53
Message-ID: (view raw or whole thread)
Lists: pgsql-hackers
On Dec 18, 2007, at 3:32 AM, Gregory Stark wrote:
>> Also, has anyone looked into adding a class of system calls that   
>> would
>> actually tell us if the kernel issued physical IO? I find it  hard  
>> to believe
>> that other RDBMSes wouldn't like to have that info...
> Yeah, I think that's called "DTrace"

That seems like way overkill...

When a read() call returns, surely the kernel knows whether it  
actually issued a physical read request to satisfy that. I don't see  
any reason why you couldn't have a version of read() that returns  
that information. I also rather doubt that we're the only userland  
software that would make use of that.
Decibel!, aka Jim C. Nasby, Database Architect  decibel(at)decibel(dot)org
Give your computer some brain candy! Team #1828

In response to


pgsql-hackers by date

Next:From: Andrew DunstanDate: 2007-12-19 01:20:11
Subject: Re: autoconf trouble in the CVS HEAD
Previous:From: KaiGai KoheiDate: 2007-12-19 01:07:25
Subject: autoconf trouble in the CVS HEAD

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group