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

Re: [HACKERS] Full page writes improvement, code update

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Koichi Suzuki <suzuki(dot)koichi(at)oss(dot)ntt(dot)co(dot)jp>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, josh(at)agliodbs(dot)com, pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] Full page writes improvement, code update
Date: 2007-04-11 01:17:38
Message-ID: 461C3732.20006@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
> In terms of idle time for gzip and other command to archive WAL offline,
> no difference in the environment was given other than the command to
> archive.   My guess is because the user time is very large in gzip, it
> has more chance for scheduler to give resource to other processes.   In
> the case of cp, idle time is more than 30times longer than user time.
> Pg_compresslog uses seven times longer idle time than user time.  On the
> other hand, gzip uses less idle time than user time.   Considering the
> total amount of user time, I think it's reasonable measure.
> 
> Again, in my proposal, it is not the issue to increase run time
> performance.   Issue is to decrease the size of archive log to save the
> storage.

Considering the relatively little amount of storage a transaction log
takes, it would seem to me that the performance angle is more appropriate.

Is it more efficient in other ways besides negligible tps? Possibly more
efficient memory usage? Better restore times for a crashed system?

Sincerely,

Joshua D. Drake

> 
> Regards;
> 


-- 

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


In response to

Responses

pgsql-hackers by date

Next:From: Kris KennawayDate: 2007-04-11 02:09:37
Subject: Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]
Previous:From: Koichi SuzukiDate: 2007-04-11 01:09:43
Subject: Re: [HACKERS] Full page writes improvement, code update

pgsql-patches by date

Next:From: Hannu KrosingDate: 2007-04-11 05:33:32
Subject: Re: [HACKERS] Full page writes improvement, code update
Previous:From: Koichi SuzukiDate: 2007-04-11 01:09:43
Subject: Re: [HACKERS] Full page writes improvement, code update

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