pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Greg Smith <gsmith@gregsmith.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Gregory Stark <stark@enterprisedb.com>
Cc: ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Cc: Postgres <pgsql-hackers@postgresql.org>
Subject: Re: posix_fadvise v22
Date: Fri, 2 Jan 2009 14:25:47 -0500 (EST)
Message-ID: <Pine.GSO.4.64.0901021416310.15834@westnet.com> (raw)
In-Reply-To: <24481.1230910405@sss.pgh.pa.us>
References: <FDDBA24E-FF4D-4654-BA75-692B3BA71B97@enterprisedb.com>
	<8347.1229012970@sss.pgh.pa.us>
	<4136ffa0812110911x4914a951o6ca502879e3dede7@mail.gmail.com>
	<87k5a6tmy7.fsf@oxford.xeocode.com>
	<603c8f070901011230t1afa6644racb715b975078054@mail.gmail.com>
	<10658.1230843315@sss.pgh.pa.us>
	<603c8f070901011843p121e40afu35c4a7bdc51c051c@mail.gmail.com>
	<Pine.GSO.4.64.0901020335150.16680@westnet.com>
	<24481.1230910405@sss.pgh.pa.us>

On Fri, 2 Jan 2009, Tom Lane wrote:

> ISTM that you *should* be able to see an improvement on even
> single-spindle systems, due to better overlapping of CPU and I/O effort.

The earlier synthetic tests I did:

http://archives.postgresql.org/pgsql-hackers/2008-09/msg01401.php

Showed a substantial speedup even in the single spindle case on a couple 
of systems, but one didn't really seem to benefit.  So we could theorize 
that Robert's test system is more like that one.  If someone can help out 
with making a more formal test case showing this in action, I'll dig into 
the details of what's different between that system and the others.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

view thread (41+ messages)  latest in thread

Message-ID: <Pine.GSO.4.64.0901021416310.15834@westnet.com>
Permalink:  ../Pine.GSO.4.64.0901021416310.15834@westnet.com/
Also on:    postgresql.org/message-id/Pine.GSO.4.64.0901021416310.15834@westnet.com

copy link · copy postgr.es

reply

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-hackers@postgresql.org
  Cc: gsmith@gregsmith.com, tgl@sss.pgh.pa.us, robertmhaas@gmail.com, stark@enterprisedb.com, itagaki.takahiro@oss.ntt.co.jp
  Subject: Re: posix_fadvise v22
  In-Reply-To: <Pine.GSO.4.64.0901021416310.15834@westnet.com>

* 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