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

Re: [HACKERS] Resurrecting per-page cleaner for

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, pgsql-patches(at)postgresql(dot)org, teramoto(dot)junji(at)lab(dot)ntt(dot)co(dot)jp
Subject: Re: [HACKERS] Resurrecting per-page cleaner for
Date: 2006-09-14 19:49:17
Message-ID: 200609141949.k8EJnHl25167@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
OK, removed from open item list.

---------------------------------------------------------------------------

Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > Tom Lane wrote:
> >> I've applied this but I'm now having some second thoughts about it,
> >> because I'm seeing an actual *decrease* in pgbench numbers from the
> >> immediately prior CVS HEAD code.
> 
> > The attached patch requires the new row to fit, and 10% to be free on
> > the page.  Would someone test that?
> 
> At the moment, I cannot replicate any consistent difference between
> CVS head with the patch, without the patch, with the patch plus your
> BLCKSZ/10 limit addition, or with a variant BLCKSZ/32 limit addition.
> That's whether I use HEAD's broken version of pgbench or one from late
> July.  So I'm feeling a tad frustrated ... but I have no evidence in
> favor of changing what is in CVS, and accordingly recommend that we
> leave well enough alone for 8.2.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq

-- 
  Bruce Momjian   bruce(at)momjian(dot)us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2006-09-14 19:51:16
Subject: Re: Mid cycle release?
Previous:From: Stephen FrostDate: 2006-09-14 19:47:05
Subject: Re: Mid cycle release?

pgsql-patches by date

Next:From: Euler Taveira de OliveiraDate: 2006-09-14 19:54:00
Subject: wrong behavior using to_char()
Previous:From: Simon RiggsDate: 2006-09-14 18:17:18
Subject: Doc patch on Warm Standby for High Availability

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