Re: jsonb format is pessimal for toast compression

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: jsonb format is pessimal for toast compression
Дата
Msg-id CAM3SWZR4JqXG1_hpArLv6wABHMXXg-gU6Sgjm2eP-YU8-Xj5yg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: jsonb format is pessimal for toast compression  (Arthur Silva <arthurprs@gmail.com>)
Ответы Re: jsonb format is pessimal for toast compression  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: jsonb format is pessimal for toast compression  (Arthur Silva <arthurprs@gmail.com>)
Список pgsql-hackers
On Tue, Aug 26, 2014 at 8:41 PM, Arthur Silva <arthurprs@gmail.com> wrote:
> The difference is small but I's definitely faster, which makes sense since
> cache line misses are probably slightly reduced.
> As in the previous runs, I ran the query a dozen times and took the average
> after excluding runs with a high deviation.

I'm not surprised that it hasn't beaten HEAD. I haven't studied the
problem in detail, but I don't think that the "cache awareness" of the
new revision is necessarily a distinct advantage.

-- 
Peter Geoghegan



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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Similar to csvlog but not really, json logs?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Add .NOTPARALLEL to contrib/Makefile