Re: Skip Orderby Execution for Materialized Views

From: Zhang Mingli <zmlpostgres(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Skip Orderby Execution for Materialized Views
Date: 2023-10-01 15:02:17
Message-ID: DC4AA0FE-4BB4-4591-90B6-BEF8C0A98192@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

HI,

> On Oct 1, 2023, at 22:54, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> For one example,
> you can't just remove the sort clause if the query uses DISTINCT ON

Hi, Tom, got it, thanks,

Zhang Mingli
HashData https://www.hashdata.xyz

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2023-10-01 16:05:49 Re: Skip Orderby Execution for Materialized Views
Previous Message Andrew Dunstan 2023-10-01 14:55:33 Re: Regression in COPY FROM caused by 9f8377f7a2