Re: drop/truncate table sucks for large values of shared buffers

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: drop/truncate table sucks for large values of shared buffers
Дата
Msg-id 20150702131237.GA16267@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: drop/truncate table sucks for large values of shared buffers  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-hackers
On 2015-07-02 16:08:03 +0300, Heikki Linnakangas wrote:
> I'm marking this as "returned with feedback" in the commitfest. In addition
> to the issues raised so far, ISTM that the patch makes dropping a very large
> table with small shared_buffers slower (DropForkSpecificBuffers() is O(n)
> where n is the size of the relation, while the current method is
> O(shared_buffers))

I think upthread there was talk about only using the O(relsize) approach
if relsize << NBuffers. That's actually a pretty common scenario,
especially in testsuites.

> I concur that we should explore using a radix tree or something else that
> would naturally allow you to find all buffers for relation/database X
> quickly.

I unsurprisingly think that's the right way to go. But I'm not sure if
it's not worth to add another layer of bandaid till were there...

Greetings,

Andres Freund



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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: raw output from copy
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: drop/truncate table sucks for large values of shared buffers