From: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
---|---|
To: | Igor Neyman <ineyman(at)perceptron(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jay Levitt <jay(dot)levitt(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? |
Date: | 2011-11-03 00:17:49 |
Message-ID: | 4EB1DDAD.9000407@archidevsys.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On 03/11/11 09:22, Igor Neyman wrote:
>
>> -----Original Message-----
>> From: Robert Haas [mailto:robertmhaas(at)gmail(dot)com]
>> Sent: Wednesday, November 02, 2011 11:13 AM
>> To: Tom Lane
>> Cc: Jay Levitt; pgsql-performance(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Fehrle | 2011-11-03 00:33:16 | Re: two table join just not fast enough. |
Previous Message | Tom Lane | 2011-11-02 23:53:02 | Re: two table join just not fast enough. |