Changes between Version 2 and Version 3 of Ticket #34597, comment 4


Ignore:
Timestamp:
May 29, 2023, 6:36:16 AM (19 months ago)
Author:
David Sanders

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #34597, comment 4

    v2 v3  
    1 EDIT: Actually please disregard this
     1EDIT: Actually please disregard this, after some investigation I found the materialise is being forced by the conditions in the query, not the lack of memory.
    22
    33The `MATERIALIZE` in the expensive plan indicates that Postgres doesn't think it has enough memory to do something more efficient.  (Sometimes Postgres will choose something less optimal in order to materialise.)
Back to Top