Re: Synchronized Scan update - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Synchronized Scan update
Date
Msg-id 200703021549.54084.josh@agliodbs.com
Whole thread Raw
In response to Re: Synchronized Scan update  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Synchronized Scan update  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Jeff,

> Right now they are just constants defined in a header, but a GUC might
> make sense. I'd like to know which version is more acceptable when I
> submit my final patch.

As much as I hate the thought of more GUCs, until we have a solid 
performance profile for synch scan we probably need them.  You should 
include the option to turn synch_scan off, such as by setting 
synch_scan_threshold to -1.

Oh, and remember that these now need to be able to take K/MB/GB.

These options should probably go in postgresql.conf under QUERY TUNING, 
with their own sub-head.

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: broken doc
Next
From: Tom Lane
Date:
Subject: Re: Arrays of Complex Types