Re: pg_avd
От | Magnus Naeslund(f) |
---|---|
Тема | Re: pg_avd |
Дата | |
Msg-id | 048a01c2d86f$2daf0710$f80c0a0a@mnd обсуждение исходный текст |
Ответ на | Re: pg_avd (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | pgsql-patches |
Maybe i can provide a datapoint on this matter. I've been using pgavd from over at gborg (Shridhar Daithankar's (i think?) code) in production for some months now. I love it. I was some hazzle to get it up, but once installed everything is smooth and nice. The vacuum + analyze seems to affect my system in an only postive way: 1) Everything seems snappier. 2) Weekly vacuum full is faster now. 3) The updates on a table with counters is updated faster nowadays. 4) pgavd is totally automatic, so just install it and run it. Well i just wanted to say that i don't care if it's an external/client process, it makes a huge differance to us lazy sob's that always forgets to vacuum all the time. It's even better that it's using pgstats to determine when to run vacuum, so after big inserts it gets vacuumed promptly. Magnus
В списке pgsql-patches по дате отправления: