Re: [PERFORM] PostgreSQL VACCUM killing CPU

2006-05-10 Thread Wu Fengguang
On Tue, May 09, 2006 at 03:19:08AM -0700, [EMAIL PROTECTED] wrote: > I have got such problem. > Im running Postgresql 7.3.2 on Linux 2.6.13. > What is see when VACCUM is running and killing my CPU is: > > Cpu(s): 3.2% us, 0.0% sy, 0.0% ni, 0.0% id, 96.8% wa, 0.0% hi, > 0.0% si > > what i am

[PERFORM] Introducing a new linux readahead framework

2006-04-24 Thread Wu Fengguang
Greetings, I'd like to introduce a new readahead framework of the linux kernel: http://www.ussg.iu.edu/hypermail/linux/kernel/0603.2/1021.html HOW IT WORKS In adaptive readahead, the context based method may be of particular interest to postgresql users. It works by peeking into the file cache a

Re: [PERFORM] Introducing a new linux readahead framework

2006-04-22 Thread Wu Fengguang
On Fri, Apr 21, 2006 at 01:34:24PM -0500, Jim C. Nasby wrote: > IIRC Mark from OSDL said he'd try testing this when he gets a chance, > but you could also try running dbt2 and dbt3 against it. Thanks for the info, I'll look into them. Regards, wu ---(end of broadcast)

Re: [PERFORM] Introducing a new linux readahead framework

2006-04-21 Thread Wu Fengguang
Hi Markus, On Fri, Apr 21, 2006 at 09:53:34AM +0200, Markus Schaber wrote: > Are there any rough estimates when this will get into mainline kernel > (if you intend to submit)? I'm not quite sure :) The patch itself has been pretty stable. To get it accepted, we must back it by good benchmarking

Re: [PERFORM] Introducing a new linux readahead framework

2006-04-21 Thread Wu Fengguang
On Thu, Apr 20, 2006 at 11:31:47PM -0500, Jim C. Nasby wrote: > > In adaptive readahead, the context based method may be of particular > > interest to postgresql users. It works by peeking into the file cache > > and check if there are any history pages present or accessed. In this > > way it can d

[PERFORM] Introducing a new linux readahead framework

2006-04-20 Thread Wu Fengguang
Greetings, I'd like to introduce a new readahead framework for the linux kernel: http://www.ussg.iu.edu/hypermail/linux/kernel/0603.2/1021.html HOW IT WORKS In adaptive readahead, the context based method may be of particular interest to postgresql users. It works by peeking into the file cache