By configuring the deletion of all outdated data older than a certain date, without using housekeeper and without using TimescaleDB-tune.
In which configuration file do I need to make certain changes and is there any configuration documentation for this request?
Hi @Coutman, why are you skipping the timescaledb-tune?
It’s safe and will just change the configuration based on your pg_config options.
You can use pg_config to discover where your postgres.conf file is coming from.
You can also see the output and understand exactly what params are changing:
Using postgresql.conf at this path:
/usr/local/var/postgres/postgresql.conf
Is this correct? [(y)es/(n)o]: y
Writing backup to:
/var/folders/cr/zpgdkv194vz1g5smxl_5tggm0000gn/T/timescaledb_tune.backup201901071520
shared_preload_libraries needs to be updated
Current:
#shared_preload_libraries = 'timescaledb'
Recommended:
shared_preload_libraries = 'timescaledb'
Is this okay? [(y)es/(n)o]: y
success: shared_preload_libraries will be updated
Tune memory/parallelism/WAL and other settings? [(y)es/(n)o]: y
Recommendations based on 8.00 GB of available memory and 4 CPUs for PostgreSQL 11
Memory settings recommendations
Current:
shared_buffers = 128MB
#effective_cache_size = 4GB
#maintenance_work_mem = 64MB
#work_mem = 4MB
Recommended:
shared_buffers = 2GB
effective_cache_size = 6GB
maintenance_work_mem = 1GB
work_mem = 26214kB
Is this okay? [(y)es/(s)kip/(q)uit]:
You can see a detailed blog post about key params here: https://www.timescale.com/blog/timescale-parameters-you-should-know-about-and-tune-to-maximize-your-performance
We also have documentation on our learn section.