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 по дате отправления
От: rchinni73@yahoo.com (beginner)
Дата:
Сообщение: psql
От: NMB Webmaster
Дата:
Сообщение: Re: Query inside transaction
FAQ