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

Re: RAID arrays and performance

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: RAID arrays and performance
Date: 2008-09-18 13:21:46
Message-ID: alpine.DEB.1.10.0809181417040.23198@aragorn.flymine.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, 29 Jan 2008, Gregory Stark wrote:
>> So, this is FYI, and also an added encouragement to implement fadvise
>> prefetching in some form or another. How's that going by the way?
>
> I have a patch which implements it for the low hanging fruit of bitmap index
> scans. it does it using an extra trip through the buffer manager which is the
> least invasive approach but not necessarily the best.

Gregory - what's the status of that patch at the moment? Will it be making 
it into a new version of Postgres, or are we waiting for it to be 
implemented fully?

It's just that our system is doing a lot of bitmap index scans at the 
moment, and it'd help to be able to spread them across the 16 discs in 
the RAID array. It's the bottleneck in our system at the moment.

Matthew

-- 
The email of the species is more deadly than the mail.

In response to

Responses

pgsql-performance by date

Next:From: Nikolas EverettDate: 2008-09-18 17:30:42
Subject: Why does this query write to the disk?
Previous:From: Albe LaurenzDate: 2008-09-18 07:34:50
Subject: Re: Statement Timeout at User Level

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