Horton

ORDER BY in materialized view example?

Maciek Sakrejda <m.sakrejda@gmail.com>

View thread View on postgr.es
From: Maciek Sakrejda <m.sakrejda@gmail.com>
To: pgsql-docs@postgresql.org
Date: 2021-11-23T06:18:46Z
Lists: pgsql-docs 
An example in the materialized view documentation [1] includes an ORDER BY
clause without a clear reason. Does it help build the index more
efficiently? I suppose it's also sort of like a CLUSTER?

But it seems like the ORDER BY should either be explained or dropped: as
is, this gives the impression that the ORDER BY can be "embedded" into the
resulting relation and persist to other queries that do not include an
explicit ORDER BY. (I recently ran across this belief, though not sure if
this was due to this example.)

Thoughts?

[1]: https://www.postgresql.org/docs/current/rules-materializedviews.html

Commits

  1. Doc: improve documentation about ORDER BY in matviews.