search

powa-team / powa

PostgreSQL Workload Analyzer
http://powa.readthedocs.io/
PostgreSQL License
768 stars 57 forks source link

Where should I enable extensions? #127

Closed sanpii closed 4 years ago

sanpii commented 4 years ago

Hello,

I’m a little confusing which extensions I should enable only for the powa database and which for all databases?

rjuju commented 4 years ago

Hello,

The only extension that may be installed on all databases is hypopg, and only if you want to have automatic index suggestion validation. All other extensions (the stats extensions as described at https://powa.readthedocs.io/en/latest/components/stats_extensions/index.html) should only be created in the powa database.

If you use the remote mode, that's the same but the stats extensions should be created on both the repository powa database and each remote server, on the powa database.

sanpii commented 4 years ago

Fine, thank you!