Add CTE barrier around core sub-query

ioguix / pgsql-bloat-estimation

Queries to mesure statistical bloat in indexes and tables for PostgreSQL

BSD 2-Clause "Simplified" License

515 stars 94 forks source link

Add CTE barrier around core sub-query #9

Closed julmon closed 4 years ago

julmon commented 5 years ago

This PR improves execution time, please see the following GIST:

Original execution plan : https://gist.github.com/julmon/2a740ea4e6c53040a428451128285483
New plan with this PR : https://gist.github.com/julmon/4aa816536fca4a6d405827db9b7f45a1

julmon commented 5 years ago

Hi, Please the chart below, it's showing effects of this optimization on blocks hit per second metric when the query is ran every minute for monitoring. btree-bloat-optim

ioguix commented 5 years ago

Helo,

I can't reproduce this on various environments. Do you have a demo schema to share so I can test?

ioguix commented 4 years ago

Some perf oriented commit has been pushed since this issue has been opened. No need to keep it open. Thanks,