| From: | Peter Geoghegan <pg(at)heroku(dot)com> |
|---|---|
| To: | Arthur Silva <arthurprs(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Larry White <ljw1001(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Kevin Grittner <kgrittn(at)ymail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Bruce Momjian <bruce(at)momjian(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
| Subject: | Re: jsonb format is pessimal for toast compression |
| Date: | 2014-08-27 03:53:15 |
| Message-ID: | CAM3SWZR4JqXG1_hpArLv6wABHMXXg-gU6Sgjm2eP-YU8-Xj5yg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Aug 26, 2014 at 8:41 PM, Arthur Silva <arthurprs(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2014-08-27 03:56:10 | Re: Add .NOTPARALLEL to contrib/Makefile |
| Previous Message | Stephen Frost | 2014-08-27 03:52:04 | Re: Similar to csvlog but not really, json logs? |