I am very interested in experimenting with functional indexes into JSON
structures. I think this could be very powerful combined with full text
search as well as constraints. It would allow for using postgres as an
unstructured data store without sacrificing the powerful indexing features,
, 2010 at 10:52 AM, Kevin Grittner kevin.gritt...@wicourts.gov
wrote:
Robert Haas robertmh...@gmail.com wrote:
On Wed, Jul 28, 2010 at 1:20 AM, Mike Lewis
mikelikes...@gmail.com wrote:
1. As-is, it's a significant *pessimization* for small arrays,
because
1. As-is, it's a significant *pessimization* for small arrays, because
the heap_tuple_untoast_attr_slice code does a palloc/copy even when one
is not needed because the data is already not toasted. I think there
needs to be a code path that avoids that.
This seems like it shouldn't be
, but
I didn't feel it warranted 3 lines.
Thanks,
Mike Lewis
detoast-headers-for-array-functions-003.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
I noticed while doing work with very large arrays that several
functions such as array_length detoast the entire array instead of
only what is required.
I found the solution to be just unpacking the header portion of the
array and ignoring the rest. Since the header (including the
dimensions) is
Woops. I sent the wrong patch. My apologies. Attached is the real
patch. Sorry, also forgot this is made against 9.0 alpha 4 tag.
Thanks,
Mike
--
Michael Lewis
lolrus.org
mikelikes...@gmail.com
On Wed, Mar 31, 2010 at 12:39 AM, Mike Lewis mikelikes...@gmail.com wrote:
I noticed while doing
On Wed, Mar 31, 2010 at 8:28 AM, Robert Haas robertmh...@gmail.com wrote:
Neat. Please add it here:
https://commitfest.postgresql.org/action/commitfest_view/open
...Robert
Thanks. Added it.
https://commitfest.postgresql.org/action/patch_view?id=292
-Mike
--
Sent via pgsql-hackers
])
union all
(select false)
limit 1
;
$$;
Full sql is here if you need more info:
http://github.com/mikelikespie/followships/blob/c1a7e8c16159018d7d1154a11169315ac6560178/followships_2.sql
(please
forgive the sloppiness, I haven't cleaned it up yet)
Thanks,
Mike Lewis
[1] http