Re: Synchronized Scan update - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Synchronized Scan update
Date
Msg-id 1172881518.13722.237.camel@dogma.v10.wvs
Whole thread Raw
In response to Re: Synchronized Scan update  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Synchronized Scan update
List pgsql-hackers
On Fri, 2007-03-02 at 15:49 -0800, Josh Berkus wrote:
> 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 

I will include them in the final patch then. 

> include the option to turn synch_scan off, such as by setting 
> synch_scan_threshold to -1.

Naturally.

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

Will do.

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

That makes sense to me.

Regards,Jeff Davis

PS: Did you happen to get my patch for testing (sent off-list)? If
testing will take a while, that's OK, I'd just like to know whether to
expect the results before feature freeze.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Arrays of Complex Types
Next
From: Josh Berkus
Date:
Subject: Re: Synchronized Scan update