Re: Dead Space Map for vacuum
От | Tom Lane |
---|---|
Тема | Re: Dead Space Map for vacuum |
Дата | |
Msg-id | 7992.1167320900@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: Dead Space Map for vacuum (Heikki Linnakangas <heikki@enterprisedb.com>) |
Список | pgsql-hackers |
Heikki Linnakangas <heikki@enterprisedb.com> writes: > I experimented with a different DSM design last winter. I got busy with > other things and never posted it AFAIR, but the idea was to store a > bitmap in the special area on every 32k heap page. That had some advantages: > * doesn't require a new dedicated shared memory area that needs to be > allocated and tuned. > * doesn't introduce a (single) new global lwlock that might become hotspot. I agree with doing something along that line (not necessarily with putting the bits into existing heap pages, but anyway with keeping the information on disk not in shared memory). Our experience with the existing FSM design has been uniformly negative; so I don't wish to add still another shared memory area that requires tricky manual size tuning. I think sooner or later we'll need to redesign FSM so it's not kept in a fixed-size shared memory area. Let's not make that mistake twice. regards, tom lane
В списке pgsql-hackers по дате отправления: