Re: jsonb format is pessimal for toast compression

From:	Josh Berkus <josh(at)agliodbs(dot)com>
To:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:	Andres Freund <andres(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Peter Geoghegan <pg(at)heroku(dot)com>, Claudio Freire <klaussfreire(at)gmail(dot)com>, "David E(dot) Wheeler" <david(at)justatheory(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Jan Wieck <jan(at)wi3ck(dot)info>
Subject:	Re: jsonb format is pessimal for toast compression
Date:	2014-09-29 03:19:17
Message-ID:	5428CFB5.3080602@agliodbs.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2014-08-08 03:17:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>  2014-08-08 04:09:22 from Larry White <ljw1001(at)gmail(dot)com>  2014-08-08 05:18:35 from Stephen Frost <sfrost(at)snowman(dot)net>   2014-08-08 06:27:51 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>   2014-08-08 15:02:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2014-08-08 16:04:01 from John W Higgins <wishdev(at)gmail(dot)com>     2014-08-08 16:20:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2014-08-08 16:26:46 from Andrew Dunstan <andrew(at)dunslane(dot)net>    2014-08-08 17:31:21 from Bruce Momjian <bruce(at)momjian(dot)us>     2014-08-09 00:25:04 from Stephen Frost <sfrost(at)snowman(dot)net>      2014-08-09 02:47:37 from Bruce Momjian <bruce(at)momjian(dot)us>       2014-08-09 17:52:32 from Stephen Frost <sfrost(at)snowman(dot)net>    2014-08-08 19:06:41 from Josh Berkus <josh(at)agliodbs(dot)com>     2014-08-08 23:10:06 from Peter Geoghegan <pg(at)heroku(dot)com>      2014-08-08 23:19:02 from Larry White <ljw1001(at)gmail(dot)com>     2014-08-09 00:26:37 from Stephen Frost <sfrost(at)snowman(dot)net>    2014-08-09 00:15:05 from Stephen Frost <sfrost(at)snowman(dot)net>     2014-08-09 00:45:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2014-08-09 01:22:22 from Andrew Dunstan <andrew(at)dunslane(dot)net>      2014-08-09 01:23:29 from Stephen Frost <sfrost(at)snowman(dot)net>       2014-08-09 01:33:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2014-08-09 01:44:32 from Stephen Frost <sfrost(at)snowman(dot)net>        2014-08-09 19:10:36 from Kevin Grittner <kgrittn(at)ymail(dot)com>         2014-08-09 19:51:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2014-08-11 19:07:44 from Robert Haas <robertmhaas(at)gmail(dot)com>           2014-08-11 19:35:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2014-08-11 19:53:41 from Stephen Frost <sfrost(at)snowman(dot)net>             2014-08-11 20:00:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2014-08-12 14:58:42 from Robert Haas <robertmhaas(at)gmail(dot)com>             2014-09-05 02:04:40 from Jan Wieck <jan(at)wi3ck(dot)info>           2014-08-11 19:39:21 from Peter Geoghegan <pg(at)heroku(dot)com>            2014-08-11 20:01:24 from Stephen Frost <sfrost(at)snowman(dot)net>             2014-08-11 20:44:05 from Peter Geoghegan <pg(at)heroku(dot)com>              2014-08-12 23:00:56 from Bruce Momjian <bruce(at)momjian(dot)us>               2014-08-13 17:41:48 from Claudio Freire <klaussfreire(at)gmail(dot)com>               2014-08-14 00:52:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                2014-08-14 01:01:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2014-08-14 01:47:15 from Andrew Dunstan <andrew(at)dunslane(dot)net>                  2014-08-14 02:36:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2014-08-14 09:29:56 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> 📎                  2014-08-14 15:04:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2014-08-14 16:10:12 from Bruce Momjian <bruce(at)momjian(dot)us>                  2014-08-14 16:22:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2014-08-14 16:52:48 from Bruce Momjian <bruce(at)momjian(dot)us>                    2014-08-14 17:13:55 from Merlin Moncure <mmoncure(at)gmail(dot)com>                    2014-08-14 17:57:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2014-08-14 18:05:48 from Peter Geoghegan <pg(at)heroku(dot)com>                      2014-08-14 21:47:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                       2014-08-14 22:10:28 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>                        2014-08-14 22:49:47 from Josh Berkus <josh(at)agliodbs(dot)com>                         2014-08-14 23:02:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2014-08-14 23:15:16 from Josh Berkus <josh(at)agliodbs(dot)com>                           2014-08-14 23:27:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                            2014-08-14 23:47:32 from Josh Berkus <josh(at)agliodbs(dot)com>                             2014-08-15 00:06:10 from Josh Berkus <josh(at)agliodbs(dot)com>                              2014-08-15 01:28:08 from Josh Berkus <josh(at)agliodbs(dot)com>                               2014-08-15 02:24:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                2014-08-15 18:51:23 from Josh Berkus <josh(at)agliodbs(dot)com>                                 2014-08-15 20:38:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                  2014-08-15 21:20:39 from Arthur Silva <arthurprs(at)gmail(dot)com>                                   2014-08-15 23:19:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                    2014-08-16 06:04:22 from Arthur Silva <arthurprs(at)gmail(dot)com>                                    2014-08-20 01:25:39 from Josh Berkus <josh(at)agliodbs(dot)com>                                     2014-08-20 15:29:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                      2014-08-20 19:18:10 from Josh Berkus <josh(at)agliodbs(dot)com>                                       2014-08-20 19:27:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                      2014-08-20 21:09:48 from Josh Berkus <josh(at)agliodbs(dot)com>                                       2014-08-20 22:42:28 from Arthur Silva <arthurprs(at)gmail(dot)com>                                        2014-08-21 21:20:33 from Josh Berkus <josh(at)agliodbs(dot)com>                                         2014-08-24 20:56:05 from Arthur Silva <arthurprs(at)gmail(dot)com>                                    2014-08-26 08:40:32 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>                                     2014-08-26 14:51:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                      2014-08-26 18:34:09 from Josh Berkus <josh(at)agliodbs(dot)com>                                       2014-08-26 18:40:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                        2014-08-26 18:41:13 from Josh Berkus <josh(at)agliodbs(dot)com>                                         2014-08-26 19:01:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                          2014-08-26 19:14:19 from Andres Freund <andres(at)2ndquadrant(dot)com>                                           2014-08-26 19:17:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                            2014-08-26 19:27:41 from Andres Freund <andres(at)2ndquadrant(dot)com>                                             2014-08-26 19:36:20 from Peter Geoghegan <pg(at)heroku(dot)com>                                             2014-08-26 19:38:53 from Josh Berkus <josh(at)agliodbs(dot)com>                                          2014-08-26 19:20:25 from Claudio Freire <klaussfreire(at)gmail(dot)com>                                          2014-08-26 22:11:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                           2014-08-27 03:41:05 from Arthur Silva <arthurprs(at)gmail(dot)com>                                            2014-08-27 03:53:15 from Peter Geoghegan <pg(at)heroku(dot)com>                                             2014-08-27 04:03:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                             2014-08-27 04:09:43 from Arthur Silva <arthurprs(at)gmail(dot)com>                                              2014-08-27 18:30:22 from Arthur Silva <arthurprs(at)gmail(dot)com> 📎                                       2014-08-26 19:16:18 from Laurence Rowe <l(at)lrowe(dot)co(dot)uk>                                  2014-08-15 22:18:30 from Josh Berkus <josh(at)agliodbs(dot)com>                     2014-08-14 18:13:44 from Bruce Momjian <bruce(at)momjian(dot)us>                      2014-08-14 18:20:28 from Josh Berkus <josh(at)agliodbs(dot)com>                     2014-08-14 18:25:31 from Oleg Bartunov <obartunov(at)gmail(dot)com>                      2014-08-14 18:49:35 from Larry White <ljw1001(at)gmail(dot)com> 📎                       2014-08-14 19:24:34 from Claudio Freire <klaussfreire(at)gmail(dot)com>                        2014-08-14 20:12:08 from Claudio Freire <klaussfreire(at)gmail(dot)com>      2014-08-09 02:41:45 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>       2014-08-09 04:09:01 from David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>  2014-08-08 14:21:46 from Andrew Dunstan <andrew(at)dunslane(dot)net>   2014-08-08 15:18:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2014-08-08 15:35:59 from Andrew Dunstan <andrew(at)dunslane(dot)net>     2014-08-08 15:54:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2014-08-08 16:35:54 from Andrew Dunstan <andrew(at)dunslane(dot)net>       2014-08-08 19:41:20 from Ants Aasma <ants(at)cybertec(dot)at>        2014-08-08 20:29:01 from Peter Geoghegan <pg(at)heroku(dot)com>    2014-09-05 02:26:56 from Jan Wieck <jan(at)wi3ck(dot)info>     2014-09-07 01:23:44 from "David E(dot) Wheeler" <david(at)justatheory(dot)com>      2014-09-12 01:01:29 from Josh Berkus <josh(at)agliodbs(dot)com>       2014-09-12 01:16:49 from Stephen Frost <sfrost(at)snowman(dot)net>       2014-09-12 01:56:04 from Arthur Silva <arthurprs(at)gmail(dot)com>        2014-09-12 16:52:11 from Josh Berkus <josh(at)agliodbs(dot)com>        2014-09-16 01:27:07 from Arthur Silva <arthurprs(at)gmail(dot)com>       2014-09-12 17:00:05 from Robert Haas <robertmhaas(at)gmail(dot)com>        2014-09-12 17:00:34 from Robert Haas <robertmhaas(at)gmail(dot)com>         2014-09-12 17:11:58 from Josh Berkus <josh(at)agliodbs(dot)com>          2014-09-12 17:25:33 from Robert Haas <robertmhaas(at)gmail(dot)com>           2014-09-12 17:52:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2014-09-12 20:30:51 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>             2014-09-15 17:12:18 from Josh Berkus <josh(at)agliodbs(dot)com>              2014-09-15 17:23:54 from Claudio Freire <klaussfreire(at)gmail(dot)com>               2014-09-15 19:09:58 from Josh Berkus <josh(at)agliodbs(dot)com>                2014-09-15 19:15:47 from Claudio Freire <klaussfreire(at)gmail(dot)com>                 2014-09-15 19:17:46 from Josh Berkus <josh(at)agliodbs(dot)com>                  2014-09-15 19:25:42 from Claudio Freire <klaussfreire(at)gmail(dot)com>                   2014-09-15 20:03:57 from Josh Berkus <josh(at)agliodbs(dot)com>                2014-09-15 21:16:24 from Robert Haas <robertmhaas(at)gmail(dot)com>                 2014-09-15 23:05:59 from Josh Berkus <josh(at)agliodbs(dot)com>                  2014-09-15 23:44:07 from Peter Geoghegan <pg(at)heroku(dot)com>                   2014-09-16 01:46:04 from Craig Ringer <craig(at)2ndquadrant(dot)com>                    2014-09-24 05:02:44 from Jan Wieck <jan(at)wi3ck(dot)info>                     2014-09-24 05:10:12 from Peter Geoghegan <pg(at)heroku(dot)com>                     2014-09-24 05:16:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                      2014-09-24 10:40:34 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>                       2014-09-24 11:51:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2014-09-16 13:31:28 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2014-09-16 16:47:39 from Josh Berkus <josh(at)agliodbs(dot)com>                     2014-09-16 16:54:48 from Robert Haas <robertmhaas(at)gmail(dot)com>                      2014-09-16 17:11:47 from Josh Berkus <josh(at)agliodbs(dot)com>                       2014-09-16 19:20:11 from Robert Haas <robertmhaas(at)gmail(dot)com>                        2014-09-16 19:42:48 from Petr Jelinek <petr(at)2ndquadrant(dot)com>                        2014-09-16 20:06:43 from Arthur Silva <arthurprs(at)gmail(dot)com>                        2014-09-16 23:36:35 from Любен Каравелов <karavelov(at)mail(dot)bg>                     2014-09-16 18:12:49 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> 📎                      2014-09-16 19:09:57 from Claudio Freire <klaussfreire(at)gmail(dot)com>                      2014-09-16 19:24:21 from Josh Berkus <josh(at)agliodbs(dot)com>                       2014-09-16 19:37:39 from Robert Haas <robertmhaas(at)gmail(dot)com>                        2014-09-16 19:54:43 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>                         2014-09-17 03:45:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2014-09-18 16:53:53 from Josh Berkus <josh(at)agliodbs(dot)com>                           2014-09-18 18:27:44 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>                            2014-09-19 12:40:14 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> 📎                             2014-09-19 14:07:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                              2014-09-22 20:24:26 from Josh Berkus <josh(at)agliodbs(dot)com>                             2014-09-24 00:51:39 from Peter Geoghegan <pg(at)heroku(dot)com>                              2014-09-24 01:06:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                             2014-09-25 16:01:08 from Andres Freund <andres(at)2ndquadrant(dot)com>                              2014-09-25 16:58:25 from Josh Berkus <josh(at)agliodbs(dot)com>                              2014-09-25 17:14:17 from Bruce Momjian <bruce(at)momjian(dot)us>                               2014-09-25 17:18:24 from Josh Berkus <josh(at)agliodbs(dot)com>                                2014-09-25 17:20:29 from Andres Freund <andres(at)2ndquadrant(dot)com>                                 2014-09-25 17:25:24 from Josh Berkus <josh(at)agliodbs(dot)com>                                  2014-09-25 17:26:48 from Andres Freund <andres(at)2ndquadrant(dot)com>                                   2014-09-25 17:29:51 from Josh Berkus <josh(at)agliodbs(dot)com>                                    2014-09-25 17:32:06 from Andres Freund <andres(at)2ndquadrant(dot)com>                                    2014-09-25 18:22:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                     2014-09-25 18:27:57 from Josh Berkus <josh(at)agliodbs(dot)com>                                      2014-09-25 18:39:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                       2014-09-25 18:46:18 from Bruce Momjian <bruce(at)momjian(dot)us>                                        2014-09-25 19:00:07 from Andres Freund <andres(at)2ndquadrant(dot)com>                                         2014-09-25 19:20:35 from Bruce Momjian <bruce(at)momjian(dot)us>                                        2014-09-29 16:30:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                         2014-09-29 17:18:31 from Stephen Frost <sfrost(at)snowman(dot)net>                                          2014-09-29 18:00:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                           2014-09-29 18:01:06 from Stephen Frost <sfrost(at)snowman(dot)net>                                         2014-09-30 00:28:45 from Bruce Momjian <bruce(at)momjian(dot)us> 📎                                     2014-09-26 03:10:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                      2014-09-26 04:40:19 from Josh Berkus <josh(at)agliodbs(dot)com>                                       2014-09-27 01:20:14 from Josh Berkus <josh(at)agliodbs(dot)com>                                        2014-09-29 03:19:17 from Josh Berkus <josh(at)agliodbs(dot)com>                                         2014-09-29 03:36:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                         2014-09-29 18:49:21 from Arthur Silva <arthurprs(at)gmail(dot)com>                                          2014-09-29 18:53:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                          2014-09-29 18:53:29 from Josh Berkus <josh(at)agliodbs(dot)com>                               2014-09-25 18:23:54 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>   2014-09-05 02:24:11 from Jan Wieck <jan(at)wi3ck(dot)info>  2014-08-08 17:09:29 from Teodor Sigaev <teodor(at)sigaev(dot)ru>   2014-08-08 17:14:17 from Teodor Sigaev <teodor(at)sigaev(dot)ru>    2014-08-08 19:34:07 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>  2014-08-08 19:50:39 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>   2014-08-12 12:41:44 from Marti Raudsepp <marti(at)juffo(dot)org>
Lists:	pgsql-hackers

In response to

• Re: jsonb format is pessimal for toast compression at 2014-09-27 01:20:14 from Josh Berkus

Responses

• Re: jsonb format is pessimal for toast compression at 2014-09-29 03:36:12 from Tom Lane
• Re: jsonb format is pessimal for toast compression at 2014-09-29 18:49:21 from Arthur Silva

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Tom Lane	2014-09-29 03:36:12	Re: jsonb format is pessimal for toast compression
Previous Message	Bruce Momjian	2014-09-29 02:33:33	Re: Collation-aware comparisons in GIN opclasses