search

expaso / hassos-addon-timescaledb

A HomeAssistant add-on containing PostgreSQL, psql client and TimeScaleDb
Apache License 2.0
50 stars 14 forks source link

feat: add the stats_temp_directory option and enable tmpfs #24

Closed snowyu closed 2 years ago

snowyu commented 2 years ago

Can use the new stats_temp_directory option to put it on the ramdisk now.

expaso commented 2 years ago

Hi @snowyu !

Thank you so much! I will pull this one in!

expaso commented 1 year ago

Hi @snowyu ,

In preparation of Postgresql 15 I am considering to pull this option from the config because it seems to be deprecated: https://pgpedia.info/s/stats_temp_directory.html

The tmpfs will still be enabled though, to let PostgreSQL profit from it.

Whats your view on this?