should i expected performance degradation over time
| От | Anibal David Acosta |
|---|---|
| Тема | should i expected performance degradation over time |
| Дата | |
| Msg-id | 000001cc6fda$7e55fd20$7b01f760$@devshock.com обсуждение исходный текст |
| Ответы |
Re: should i expected performance degradation over time
Re: should i expected performance degradation over time |
| Список | pgsql-performance |
Sometimes I read that postgres performance is degraded over the time and something people talk about backup and restore database solve the problem.
It is really true?
I have postgres 9.0 on a windows machine with The autovacuum is ON
I have some configuration tables
And a couple of transactional table.
Transactional table has about 4 millions of rows inserted per day.
In the midnight all rows are moved to a historical table and in the historical table rows are about 2 months, any transaction older than 2 months are deleted daily.
So, my question is, if Should I expect same performance over time (example: after 1 year) or should I expect a degradation and must implements come technics like backup restore every certain time?
Thanks!!
В списке pgsql-performance по дате отправления: