Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? - Mailing list pgsql-performance

From Igor Neyman
Subject Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
Date
Msg-id F4C27E77F7A33E4CA98C19A9DC6722A2084DFFF7@EXCHANGE.corp.perceptron.com
Whole thread Raw
In response to Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
List pgsql-performance

> -----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 :)

pgsql-performance by date:

Previous
From: CS DBA
Date:
Subject: Poor performance on a simple join
Next
From: Yeb Havinga
Date:
Subject: Re: Intel 710 pgbench write latencies