Re: [PATCHES] Proposed patch: synchronized_scanning GUCvariable - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] Proposed patch: synchronized_scanning GUCvariable
Date
Msg-id 26480.1201644221@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] Proposed patch: synchronized_scanning GUCvariable  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List pgsql-hackers
Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
> Tom Lane wrote:
> Or is someone prepared to argue that there are no applications out
> there that will be broken if the same query, against the same unchanging
> table, yields different results from one trial to the next? 
> 
> Won't even autovacuum "analyze" cause this too if the
> new stats changes the plan?

Given that the table is unchanging, that's moderately unlikely to happen
(especially for "select * from foo" ;-))
        regards, tom lane


pgsql-hackers by date:

Previous
From: Caleb Welton
Date:
Subject: Re: Transition functions for SUM(::int2), SUM(::int4, SUM(::int8])
Next
From: Tom Lane
Date:
Subject: Re: Large pgstat.stat file causes I/O storm