| From: | Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
|---|---|
| To: | Peter Geoghegan <pg(at)heroku(dot)com> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Oleg Bartunov <obartunov(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>, Maciek Sakrejda <maciek(at)heroku(dot)com> |
| Subject: | Re: jsonb and nested hstore |
| Date: | 2014-03-20 12:32:18 |
| Message-ID: | CAPpHfdt3K4mt4rBEAQPOAGFx1-WtrVTZR58kxPiyV-0w3GTNeg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I've noticed two commits on github.
commit b8199ee3c2506ab81b47a0b440363fc90c0d6956
Author: Peter Geoghegan <pg(at)heroku(dot)com>
Date: Wed Mar 19 02:02:16 2014 -0700
For jsonb_hash_ops, hash less
By limiting the GIN entries to the least-nested level, the delicious.com
sample JSON dataset index shrinks in size from 382MB to 255MB without
any apparent downside.
commit 2cea5213dba011625fc0d5c6b447e838080087b1
Author: Peter Geoghegan <pg(at)heroku(dot)com>
Date: Wed Mar 19 02:13:42 2014 -0700
Revert "For jsonb_hash_ops, hash less"
This might be workable with another approach, but leave it for now. This
reverts commit b8199ee3c2506ab81b47a0b440363fc90c0d6956.
Besides implementation, what the idea was here? For me, it's impossible to
skip any single element, because it's possible for query to include only
this element. If we skip that element, we can't answer corresponding query
no more.
------
With best regards,
Alexander Korotkov.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Etsuro Fujita | 2014-03-20 12:59:22 | Re: inherit support for foreign tables |
| Previous Message | Fujii Masao | 2014-03-20 12:03:46 | Re: effective_cache_size cannot be changed by a reload |