Yep, agreed. A simple lexical macro-like approach to test "if it works" could
be a simple approach to see if inlining a piece of sql would not break the main
query?
Laurent Hasson
Sent from my BlackBerry Passport
Original Message
From: Tom Lane
Sent: Saturday, November 12, 2016 14:59
To: l...
"l...@laurent-hasson.com" writes:
> I wish there were a way to force inlining, or some other mechanism as the
> performance difference is large here. I'll be using the inlining approach
> when possible, but the SQL Function approach is simpler and will likely be
> more suitable for some develop
On Fri, Nov 11, 2016 at 7:19 AM, Henrik Ekenberg wrote:
> Hi,
>
> I have a select moving around a lot of data and takes times
> Any advice tuning this query ?
>
> EXPLAIN (ANALYZE ON, BUFFERS ON)
>
When accessing lots of data, sometimes the act of collecting timing on all
of the actions makes th
