Re: Black Hat: New database attack revealed

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Black Hat: New database attack revealed
Дата
Msg-id 46B1D5AC.6080203@postgresql.org
обсуждение исходный текст
Ответ на Re: Black Hat: New database attack revealed  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-advocacy
Magnus Hagander wrote:
>> In our case, would it even be possible given WAL?
>
>From how I read it they rely on the time to insert into BTREE indexes (or
> to lookup for unique keys etc). I don't see how WAL would change that (well
> the values changes, but you would still see timing differences in cases
> with lots-of-equal-keys-in-the-index or such things)

Yeah, my reasoning was a little screwed up - now corrected by Greg :-)

> But I'd say that the simple act of fsyncing after every commit would in
> most cases destroy any difference between these key lookups - that random
> element coming in from different platter locations would be much higher
> than the btree difference in my guess...

Yeah.

Regards, Dave.

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Black Hat: New database attack revealed
Следующее
От: Lukas Kahwe Smith
Дата:
Сообщение: Re: Black Hat: New database attack revealed