Re: Tables dissapearing
От | Kamil Srot |
---|---|
Тема | Re: Tables dissapearing |
Дата | |
Msg-id | 46D32DF8.1090804@nlogy.com обсуждение исходный текст |
Ответ на | Re: Tables dissapearing (Andrew Sullivan <ajs@crankycanuck.ca>) |
Ответы |
Re: Tables dissapearing
|
Список | pgsql-general |
Andrew Sullivan wrote: > On Mon, Aug 27, 2007 at 07:15:44PM +0200, Kamil Srot wrote: > >> OK, I'll drop the full part and do it less often... >> > > This doesn't address your problem, but when you move from VACUUM FULL > to VACUUM, you want to do it _more_ often, not less. > > Sure, I ment it like I'll do the FULL vacuum less often than daily and do daily the plain vacuum command. > But given what you've posted, I am not even a little bit convinced > your script is working as you think it is. You're clearly not > managing to vacuum the entire database sometimes. > Well, I do list all databases with the command "psql -U postgres -l -t" and with some shell coding I do vacuum all shown databases... I don't think there is some problem in it... If you do see some, can you give me a hint? Thank you, -- Kamil
В списке pgsql-general по дате отправления: