Matt Freeman - nonuby

Thailand, SE Asia

Asking stupid questions is my game...twitter @nonuby

Dec
11
comment Postgresql Offset Behavior with json column
I have reported to pg-bugs and will wait to see what happens (its a moderated list), I'll leave this marked unanswered for a day or two incase for some odd reason it's by design.
Dec
11
comment Postgresql Offset Behavior with json column
Thanks for the tests. Just to add we are not using RoR, but Clojure, as many developers are now pushing Postgres as a NoSQL replacement (blogs, conferences, microbenchmarks) Im sure these scenarios will become more common across a multitude of stacks.
Dec
11
comment Postgresql Offset Behavior with json column
Someone asked (and then removed answer, possibly @Denis?) if a non-indexed-json field behaves the same. There is another non indexed field on the table called version (int not null) SELECT couchcontacts."version" FROM couchcontacts OFFSET 10000 LIMIT 10 returns in 14ms. vs blob->>'field' taking 4158ms - 12,000ms
Dec
11
revised Postgresql Offset Behavior with json column
added 310 characters in body
Dec
11
comment Postgresql Offset Behavior with json column
Given ->> is a built in operator, shouldnt postgresql know this isnt causing side-effects? is there a way to hint it is none side-effect causing?. Updated with explain analyze
Dec
11
awarded Yearling
Dec
11
awarded Yearling
Dec
11
asked Postgresql Offset Behavior with json column
Nov
24
awarded Popular Question
Nov
19
awarded Autobiographer
Nov
4
awarded Autobiographer
Nov
4
awarded Autobiographer
Nov
4
awarded Autobiographer
Nov
4
awarded Autobiographer
Nov
4
awarded Autobiographer
Nov
4
awarded Autobiographer
Nov
4
awarded Autobiographer
Nov
4
awarded Autobiographer
Nov
4
awarded Autobiographer
Nov
4
awarded Autobiographer
1 2 3 4 5