Are there tuning parameters that don't take effect immediately?
| От | Michael Nolan |
|---|---|
| Тема | Are there tuning parameters that don't take effect immediately? |
| Дата | |
| Msg-id | CAOzAqu+e979Ezq94W5SpCrJ_9iiW7HyxU7eaQFo64rPKhvZS8w@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Are there tuning parameters that don't take effect immediately?
Re: Are there tuning parameters that don't take effect immediately? |
| Список | pgsql-performance |
Last night I was doing some tuning on a database The longest query I was running was taking around 160 seconds. I didn't see much change in the running time for that query, even after restarting PG.
Today, with roughly the same system load (possibly even a bit heavier load), that query is running about 40 seconds.
Are there tuning parameters in postgresql.conf that don't take effect right away, even after a restart of PG? The only thing I can come up that's happened since last night was that we ran the nightly vacuum analyze on that database, but I did not change the statistics target. Today, with roughly the same system load (possibly even a bit heavier load), that query is running about 40 seconds.
В списке pgsql-performance по дате отправления: