REFRESH MATERIALIZED VIEW CONCURRENTLY interaction with ORDER BY

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: awad(at)zyper(dot)com
Subject: REFRESH MATERIALIZED VIEW CONCURRENTLY interaction with ORDER BY
Date: 2019-04-04 14:54:29
Message-ID: 155438966988.726.7863901426737518005@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/sql-refreshmaterializedview.html
Description:

On 10.7 we hit a case where the backing query had an order by clause and a
concurrent refresh updated it differently than a normal refresh. This is a
bit of an odd corner case given that up till that point, views would respect
the ordering.

It's not explicit that CONCURRENTLY populates the data any differently than
normal, specifically, in a way that means the ordering in the backing query
is not always maintained, depending on the order of updates.

Reading through the comment at
https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/commands/matview.c;h=2aac63296bfee535af3ea660c617b265d7ec8042;hb=HEAD#l548
I can see the logic in that, but it could use an explicit mention in the
CONCURRENTLY section. Not sure if there's any plan for changing the
behaviour either.

Also the existing sentence "If you want the data to be ordered upon
generation, you must use an ORDER BY clause in the backing query." sort of
implies that the ORDER BY will be respected.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Jonathan S. Katz 2019-04-04 16:23:56 Re: Responsive images in pgweb docs
Previous Message Peter Eisentraut 2019-04-04 11:17:04 Re: Responsive images in pgweb docs