Re: Removing freelist (was Re: Should I implement DROP INDEX CONCURRENTLY?)

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Removing freelist (was Re: Should I implement DROP INDEX CONCURRENTLY?)
Дата
Msg-id CA+TgmoaOFLiAf8wEqJKv7xvf+TdybJ4wCkQxkO95uXtJ=yc8Bw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Removing freelist (was Re: Should I implement DROP INDEX CONCURRENTLY?)  (Jim Nasby <jim@nasby.net>)
Ответы Re: Removing freelist (was Re: Should I implement DROP INDEX CONCURRENTLY?)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sat, Jan 21, 2012 at 5:29 PM, Jim Nasby <jim@nasby.net> wrote:
> We should also look at having the freelist do something useful, instead of just dropping it completely. Unfortunately
that'sprobably more work...
 

That's kinda my feeling as well.  The free list in its current form is
pretty much useless, but I don't think we'll save much by getting rid
of it, because that's just a single test.  The expensive part of what
we do while holding BufFreelistLock is, I think, iterating through
buffers taking and releasing a spinlock on each one (!).  So I guess
my vote would be to leave it alone pending further study, and maybe
remove it later if we can't find a way to rejigger it to be more
useful.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Vacuum rate limit in KBps
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Publish checkpoint timing and sync files summary data to pg_stat_bgwriter