pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16255: No respect for 'not materialized' on CTEs with group by
2+ messages / 2 participants
[nested] [flat]

* BUG #16255: No respect for 'not materialized' on CTEs with group by
@ 2020-02-12 12:28  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2020-02-12 12:28 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: robfordww@gmail.com

The following bug has been logged on the website:

Bug reference:      16255
Logged by:          Robert Ford
Email address:      robfordww@gmail.com
PostgreSQL version: 12.1
Operating system:   Windows
Description:        

I have an simple CTE expression with group by and a string_aggr() function,
and Postgresql seems to materialize it anyhow, even if 'not materialized' is
instructed. I can't see that this is documented behaviour.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #16255: No respect for 'not materialized' on CTEs with group by
@ 2020-02-12 15:11  Tom Lane <tgl@sss.pgh.pa.us>
  parent: PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2020-02-12 15:11 UTC (permalink / raw)
  To: robfordww@gmail.com; +Cc: pgsql-bugs@lists.postgresql.org

PG Bug reporting form <noreply@postgresql.org> writes:
> I have an simple CTE expression with group by and a string_aggr() function,
> and Postgresql seems to materialize it anyhow, even if 'not materialized' is
> instructed. I can't see that this is documented behaviour.

Since you haven't given a concrete example, nobody else can see whether it
is either.  But in general, there is no guarantee that "NOT MATERIALIZED"
will do anything.  There are multiple conditions that will prevent
inlining a CTE, either for semantic or implementation reasons.

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2020-02-12 15:11 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-02-12 12:28 BUG #16255: No respect for 'not materialized' on CTEs with group by PG Bug reporting form <noreply@postgresql.org>
2020-02-12 15:11 ` Tom Lane <tgl@sss.pgh.pa.us>

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