Re: VACUUM FULL memory requirements

Поиск
Список
Период
Сортировка
От David Schnur
Тема Re: VACUUM FULL memory requirements
Дата
Msg-id 50000b2e0912210921x3589c077g30d04ed6a559d673@mail.gmail.com
обсуждение исходный текст
Ответ на Re: VACUUM FULL memory requirements  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
I've been doing more testing on several different machines, but still haven't found a solution to my problem where VACUUM FULL is running out of memory.  Besides the original case on RHEL4, I've been able to reproduce it on both Windows and OSX, with 3GB and 5GB RAM, respectively.  Interestingly, it always fails on a request size of 330, even across differently-sized databases running on machines with different amounts of memory.

As far as that new tool you're describing, for my purposes it doesn't make much difference whether it's a stand-alone application or a command, though a command is a little more convenient.  The ability to free space concurrent with other database operations would be nice, but I feel like the introduction of serialization failures would negate that advantage, since I at least would end up running it non-concurrently to avoid dealing with them.

I actually find the current design of VACUUM FULL reasonable enough, if I could figure out what's causing this memory issue and prevent it from happening.

David

В списке pgsql-admin по дате отправления:

Предыдущее
От: Lewis Kapell
Дата:
Сообщение: Re: Backslashes in bytea values
Следующее
От: Julius T
Дата:
Сообщение: starting postgres with several Data directories