Re: VACUUM memory management
| От | Alvaro Herrera |
|---|---|
| Тема | Re: VACUUM memory management |
| Дата | |
| Msg-id | 20191209185428.GA11748@alvherre.pgsql обсуждение исходный текст |
| Ответ на | VACUUM memory management (Ibrar Ahmed <ibrar.ahmad@gmail.com>) |
| Ответы |
Re: VACUUM memory management
|
| Список | pgsql-hackers |
On 2019-Dec-09, Ibrar Ahmed wrote: > Hi, > > The memory consumption of VACUUM has some issues and could be improved. > Some of its limitations are recorded in the comments of the “vacuumlazy.c” > file. The current design of VACUUM memory usage is that it stores the TID > in a fixed-size array which is allocated at the start, based upon > maintenance_work_mem. There are three problems with that design Did you see this thread? https://postgr.es/m/CAGTBQpbDCaR6vv9=scXzuT8fSbckf=a3NgZdWFWZbdVugVht6Q@mail.gmail.com -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: