2000x slower - When to avoid using JSONB in PostgreSQL

added by JudahGabriel
9/6/2016 3:23:48 PM

1 Kicks, 214 Views

With PostgreSQL's JSON support, innocent queries can blow up on you. The hidden cost is that your data inside JSON blobs don't have statistics tracked by PostgreSQL, so the query planner is flying blind. As a result of our using JSONB, we've seen some of our queries execute 2000x slower and our tables grow 30% larger.