Re: performance: use pread instead of lseek+read

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Manfred Spraul <manfred(at)colorfullife(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: performance: use pread instead of lseek+read
Date: 2003-02-25 14:35:58
Message-ID: 10186.1046183758@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Manfred Spraul <manfred(at)colorfullife(dot)com> writes:
> Do you know that empty lseeks foul up readahead recognition on some OS?
> If yes, which OS? I've checked FreeBSD and Linux, they don't do it.

Who knows? But it would be folly to extrapolate from those two
datapoints to all the platforms we support.

> - which benchmark would be interesting?

Something that measures the performance "in context", that is as part of
normal database activity, not just the syscall overhead. pgbench is
notoriously hard to get reproducible numbers out of, but you could try
it if you like.

> - which OS did you use when you got 'no manpage for pread'?

HPUX 10.20.

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Jeroen T. Vermeulen 2003-02-25 15:42:30 Re: psql patch
Previous Message Karel Zak 2003-02-25 08:38:54 Re: to_char PL/MI fix