Changes between Initial Version and Version 1 of Ticket #34597, comment 4


Ignore:
Timestamp:
May 29, 2023, 5:19:08 AM (18 months ago)
Author:
David Sanders

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #34597, comment 4

    initial v1  
    11The `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.)
    22
    3 Another thing to try is turning off materialisation to see what plan it uses:
     3Try turning off materialisation to see what plan it uses:
    44
    55{{{
Back to Top