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,
durabi
Thu, Aug 5, 2010 at 10:52 AM, Kevin Grittner wrote:
> Robert Haas wrote:
> > On Wed, Jul 28, 2010 at 1:20 AM, Mike Lewis
> > wrote:
> >>>
> >>> > 1. As-is, it's a significant *pessimization* for small arrays,
> >>> > because the hea
>
>
> > 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 s
ed a comment. Not quite sure if it's the appropriate format, 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 sub
On Wed, Mar 31, 2010 at 8:28 AM, Robert Haas 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 mailing list (pgsql
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 wrote:
> I noticed while doing work with very la
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
er_id = $1 and follower_ids
@> ARRAY[$2])
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 c
