News for hackers. Stuff that matters.

A comment on Better JSON in Postgres with PostgreSQL 14. Parent comment

Re:Better JSON in Postgres with PostgreSQL 14 by yarcob on Tuesday June 01, 2021 @04:31PM (#27360878)
PostgreSQL is vulnerable to certain workloads. For example, if you keep appending something to a text column, you'll use up a lot of disc space since PG will copy the row each time and keep deleted copies around until autovacuum comes along.

Of course, if you are doing this then you are using your database wrong -- but it's still something that's easy to run into.

[ Parent | on HN ]
Re:Better JSON in Postgres with PostgreSQL 14 by jkatz05 on Tuesday June 01, 2021 @04:42PM (#27361002)
PostgreSQL 14 made improvements to this area around indexing:

https://www.postgresql.org/docs/14/btree-implementation.html...

[ Parent | on HN ]
Re:Better JSON in Postgres with PostgreSQL 14 by mattashii on Tuesday June 01, 2021 @05:42PM (#27361738)
Yes, but that doesn't cover the problem of bloat in the TOAST tables due to excessive churn of large attributes that was mentioned in the parent post.
[ Parent | on HN ]