Dump / restore for optimization?
От
lec
Тема
Dump / restore for optimization?
Дата
Msg-id
40DAFAC1.1090409@streamyx.com
Список
Дерево обсуждения
Dump / restore for optimization? lec <limec@streamyx.com>
Re: Dump / restore for optimization? Bill Moran <wmoran@potentialtech.com>
Re: Dump / restore for optimization? Shridhar Daithankar <shridhar@frodo.hserus.net>
Re: Dump / restore for optimization? Tom Lane <tgl@sss.pgh.pa.us>
Re: Dump / restore for optimization? Bill Montgomery <billm@lulu.com>
I always have to dump & restore to make a database (which is in use for a few months) efficient again. I have scheduled nightly vacuum analyze, but only dump & restore can make the database efficient again. Has anyone experience this? -lec
В списке pgsql-general по дате отправления