Re: Synchronized Scan WIP patchf - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Synchronized Scan WIP patchf
Date
Msg-id 200703222140.l2MLeh118350@momjian.us
Whole thread Raw
In response to Re: Synchronized Scan WIP patch  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-patches
Your patch has been added to the PostgreSQL unapplied patches list at:

    http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

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


Jeff Davis wrote:
> On Thu, 2007-03-22 at 16:43 -0400, Bruce Momjian wrote:
> > Will use '16' rather than '100'.
> >
> > Your patch has been added to the PostgreSQL unapplied patches list at:
> >
> >     http://momjian.postgresql.org/cgi-bin/pgpatches
> >
> > It will be applied as soon as one of the PostgreSQL committers reviews
> > and approves it.
> >
>
> Here is the latest version, which includes the change to report every 16
> pages.
>
> This patch has the following improvements:
>
>  * reporting interval to 16 pages
>  * rearranges the scan location tracing output to work regardless of the
> reporting interval. Previously it did not trace the output correctly if
> the logging interval was not an even multiple of the reporting interval
>  * GUC trace_sync_seqscan=<bool> now controls whether the DEBUG output
> is generated or not. If this is true, a lot of logging output will be
> generated at DEBUG3.
>  * You can set sync_seqscan_threshold=<-1.0 ... 100.0>. Positive values
> are treated as a fraction of NBuffers. Negative values disable sync
> scans.
>
> Still TODO:
>
>  * Publish my test results (I've collected much of the raw data already
> on this version of the patch)
>  * SGML documentation (after we stabilize the GUC names and meanings)
>  * Possibly remove sync_seqscan_threshold=<real> and instead use a
> simple enable/disable boolean that sets the threshold at a constant
> fraction of NBuffers (most likely the same fraction as Simon's recycle
> buffers patch)
>
> Regards,
>     Jeff Davis

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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

pgsql-patches by date:

Previous
From: "Mike Rylander"
Date:
Subject: Re: [HACKERS] xml2 contrib patch supporting default XML namespaces
Next
From: Alvaro Herrera
Date:
Subject: Re: LIMIT/SORT optimization