Can I get a performance improve just by restarting the

Question

PostgreSQL (English)

base c

Can I get a performance improve just by restarting the

postgresql?

#programming #russian

0

14.06.2024

1 ответов

6 просмотров

Stefanie Janine Stölting · Accepted Answer

Nope, that will do the opposite of what you want. By restarting you empty the cached data and everything, data and indexes) have to be grabbed from disk. To increase performance you might have to change the configuration. You should check for slow queries and add indexes, if needed. Identity doublicate indexes and clean them up. Check for the right data types. For example VARCHAR(n) is always slower than TEXT. Every little bit might count. If you don't know what you are doing, hire an expert and start learning.

169 похожих чатов

Can I get a performance improve just by restarting the

1 ответов

Похожие вопросы