From: Gavin Flower <GavinFlower@archidevsys.co.nz>
To: Igor Neyman <ineyman@perceptron.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jay Levitt <jay.levitt@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
Date: Thu, 03 Nov 2011 13:17:49 +1300
Message-ID: <4EB1DDAD.9000407@archidevsys.co.nz> (raw)
In-Reply-To: <F4C27E77F7A33E4CA98C19A9DC6722A2084DFFF7@EXCHANGE.corp.perceptron.com>
References: <CANSg5mqt+7j1SU2Gu2tZ_c_vdzCJPkymxEqaQ-OjRXfz=Pfimg@mail.gmail.com>
<29918.1320244719@sss.pgh.pa.us>
<CA+TgmoY_a34rAWCxBaA+3RtSv9tBo0PaRyxnNH4-rtJ5XkBQdA@mail.gmail.com>
<F4C27E77F7A33E4CA98C19A9DC6722A2084DFFF7@EXCHANGE.corp.perceptron.com>
On 03/11/11 09:22, Igor Neyman wrote:
>
>> -----Original Message-----
>> From: Robert Haas [mailto:robertmhaas@gmail.com]
>> Sent: Wednesday, November 02, 2011 11:13 AM
>> To: Tom Lane
>> Cc: Jay Levitt; pgsql-performance@postgresql.org
>> Subject: Re: Guide to PG's capabilities for inlining, predicate
>> hoisting, flattening, etc?
>> .......
>> .......
>> Perhaps we could let people say
>> something like WITH x AS FENCE (...) when they want the fencing
>> behavior, and otherwise assume they don't (but give it to them anyway
>> if there's a data-modifying operation in there).
>>
>> ....
>> ....
>> --
>> Robert Haas
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>
> Hints.... here we come :)
>
Is that a hint???
[Sorry, my perverse sense of humour kicked in]
I too would like CTE's to take part in optimisation - as I don't like
the mass slaughter of kittens, but I still want to pander to my speed
addiction.
So I think that having some sort of fence mechanism would be good.
Cheers,
Gavin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: GavinFlower@archidevsys.co.nz, ineyman@perceptron.com, robertmhaas@gmail.com, tgl@sss.pgh.pa.us, jay.levitt@gmail.com
Subject: Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
In-Reply-To: <4EB1DDAD.9000407@archidevsys.co.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox