Unix Technical Forum

Re: WAL: O_DIRECT and multipage-writer

This is a discussion on Re: WAL: O_DIRECT and multipage-writer within the pgsql Hackers forums, part of the PostgreSQL category; --> Hi, Mark. Mark Wong <markw@osdl.org> wrote: > In light of this thread, have you compared the performance on > ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-11-2008, 04:11 AM
ITAGAKI Takahiro
 
Posts: n/a
Default Re: WAL: O_DIRECT and multipage-writer

Hi, Mark.

Mark Wong <markw@osdl.org> wrote:

> In light of this thread, have you compared the performance on
> Linux-2.4?


No, but I'm just testing my patch on Linux-2.4 with a middle-range server.
I will report the results sometime soon.


By the way, I found the debug option (XLOG_MULTIPAGE_WRITER_DEBUG) was enabled
in your prior benchmarks. It writes logs a lot.
I hope performance doesn't fall at least without debug.

> So the new baseline result with 8.0.1:
> Throughput: 3639.97
> Results with the patch but open_direct not set:
> Throughput: 3494.72
> Results with the patch and open_direct set:
> Throughput: 3489.69


---
ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>
NTT Cyber Space Laboratories


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-11-2008, 04:12 AM
Mark Wong
 
Posts: n/a
Default Re: WAL: O_DIRECT and multipage-writer

On Wed, Mar 23, 2005 at 01:55:46PM +0900, ITAGAKI Takahiro wrote:
> Hi, Mark.
>
> Mark Wong <markw@osdl.org> wrote:
>
> > In light of this thread, have you compared the performance on
> > Linux-2.4?

>
> No, but I'm just testing my patch on Linux-2.4 with a middle-range server.
> I will report the results sometime soon.
>
>
> By the way, I found the debug option (XLOG_MULTIPAGE_WRITER_DEBUG) was enabled
> in your prior benchmarks. It writes logs a lot.
> I hope performance doesn't fall at least without debug.


That's 'log_min_messages = debug1' right? Maybe I should give it
another go with that set back to the default.

Thanks,
Mark

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:10 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com