Postgres Pro
Downloads
Home   >   mailing lists

Re: Introducing a new linux readahead framework - Mailing list pgsql-performance

From Michael Stone
Subject Re: Introducing a new linux readahead framework
Date
Msg-id 20060427114340.GE31328@mathom.us
Whole thread Raw
In response to Re: Introducing a new linux readahead framework  (Michael Stone <mstone+postgres@mathom.us>)
List pgsql-performance
Tree view 
On Wed, Apr 26, 2006 at 10:43:48AM -0400, Michael Stone wrote:
>patch a 512k blocksize would get ~100MB/s. I'm now watching to see how
>it does over a couple of days on real-world workloads.

I've got one DB where the VACUUM ANALYZE generally takes 11M-12M ms;
with the patch the job took 1.7M ms. Another VACUUM that normally takes
between 300k-500k ms took 150k. Definately a promising addition.

Mike Stone

pgsql-performance by date:

Previous
From: "Guillaume Smet"
Date:
Subject: Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql
Next
From: "andremachado"
Date:
Subject: Firebird 1.5.3 X Postgresql 8.1.3 (linux Firebird 1.5.3 X Postgresql 8.1.3 (linux and and windows)]