I'd also add ANALYZED/NOT ANALYZED. This should force it behave like 'create table, analyze, select' with statistics used in second query plan.
P.S. defaults can be configurable.
20 лист. 2012 02:22, "Gavin Flower" <GavinFlower@xxxxxxxxxxxxxxxxx> напис.
On 15/11/12 15:03, Peter Geoghegan wrote:
On 15 November 2012 01:46, Andrew Dunstan <andrew@xxxxxxxxxxxx> wrote:How about adding the keywords FENCED and NOT FENCED to the SQL definition of CTE's - with FENCED being the default?
It cuts both ways. I have used CTEs a LOT precisely because this behaviourIs the "OFFSET 0" hack really so bad? We've been telling people to do
lets me get better plans. Without that I'll be back to using the "offset 0"
hack.
that for years, so it's already something that we've effectively
committed to.
Cheers,
Gavin
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
