tag:blogger.com,1999:blog-7476449567742726187.post8133534187903406800..comments2023-12-18T12:25:52.296-08:00Comments on Database Soup: SQLnoSQL: pg_shard and JSONB, part 1Josh Berkushttp://www.blogger.com/profile/09671139717468724246noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7476449567742726187.post-28242702689060795802015-11-16T09:33:33.263-08:002015-11-16T09:33:33.263-08:00i've been using pg 9.5 json recently. tis my f...i've been using pg 9.5 json recently. tis my first in depth exposure. all i can say is wow ... almost perfect. i'm still doing simple queries, basically the extract stage from json logging events into tables, so i haven't tested the optimizer much. however, the merge queries against +1million json tuples are quite performant. my only grumble would be null handling and lack of range queries on arrays. John the Scotthttps://www.blogger.com/profile/14024505963810601849noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-53462385110007246922015-07-02T11:22:19.262-07:002015-07-02T11:22:19.262-07:00Sorry, I've been backlogged. I went down the ...Sorry, I've been backlogged. I went down the rabbit hole of engineering a JSON benchmark; I should have an update to this soon.Josh Berkushttps://www.blogger.com/profile/09671139717468724246noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-55381641381913546732015-06-30T09:43:55.847-07:002015-06-30T09:43:55.847-07:00Hello,
This blog post has been very useful in get...Hello,<br /><br />This blog post has been very useful in getting started with pg_shard. Will the next part be available anytime soon? Thank youAnonymoushttps://www.blogger.com/profile/08568709833555387797noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-26244383034964821192014-12-12T12:52:16.638-08:002014-12-12T12:52:16.638-08:00The follow-up to this blog post will be delayed by...The follow-up to this blog post will be delayed by technical and work-conflict issues.Josh Berkushttps://www.blogger.com/profile/09671139717468724246noreply@blogger.com