search

hydradatabase / hydra

Hydra: Column-oriented Postgres. Add scalable analytics to your project in minutes.
https://www.hydra.so
Apache License 2.0
2.83k stars 76 forks source link

[columnar] turn off caching when building an index #250

Closed JerrySievert closed 7 months ago

JerrySievert commented 7 months ago

when an index is being built, we should disable the column cache for the duration to stop multiple cache evictions on large tables.

wuputah commented 7 months ago

can we also do this for analyze?

JerrySievert commented 7 months ago

can we also do this for analyze?

I can do it for vacuum and the vacuum udf.

wuputah commented 7 months ago

That might be good idea as well -- I don't have data at present that vacuum is problematic but I can test that.

JerrySievert commented 7 months ago

updated for analyze, vacuum, and vacuum udf as well