Re: Initial prefetch performance testing - Mailing list pgsql-hackers

From Zdenek Kotala
Subject Re: Initial prefetch performance testing
Date
Msg-id 48D8E092.2020301@sun.com
Whole thread Raw
In response to Re: Initial prefetch performance testing  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-hackers
Greg Smith napsal(a):
> On Mon, 22 Sep 2008, Gregory Stark wrote:

> 
>> I'm quite surprised Solaris doesn't support posix_fadvise -- perhaps 
>> it's in some other version of Solaris?

Solaris has only fake variant of posix_fadvise. See 
http://src.opensolaris.org/source/xref/onnv/onnv-gate/usr/src/lib/libc/port/gen/posix_fadvise.c

UFS has own optimization. For example if it detects sequential scan then  file cache is limited on 80kB. Or it also has
prefetching.

ZFS has intelligent read patter recognitions algorithms and other 
improvements.
    Zdenek


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Proposed patch: make SQL interval-literal syntax work per spec
Next
From: Tom Lane
Date:
Subject: Re: Proposal: move column defaults into pg_attribute along with attacl