Postgres Pro
Downloads
Home   >   mailing lists

Re: Apparent missed query optimization with self-join and inner grouping - Mailing list pgsql-general

From Michael Lewis
Subject Re: Apparent missed query optimization with self-join and inner grouping
Date
Msg-id CAHOFxGqpP72wNVX7KdvFHRXARsiBA6AN-N+fZfafah+uocgV_g@mail.gmail.com
Whole thread Raw
In response to Apparent missed query optimization with self-join and inner grouping  (Zack Weinberg <zackw@panix.com>)
List pgsql-general
Tree view
Subqueries are evaluated separately when they include an aggregate or window function as I understand it. I agree that it would be helpful in your case if that outside qual was pushed inside.

I assume this query is generated by an ORM and you don't just have the option to simply change it?

pgsql-general by date:

Previous
From: Ben Chobot
Date:
Subject: Re: 12.3 replicas falling over during WAL redo
Next
From: Curt Kolovson
Date:
Subject: how reliable is pg_rewind?