News for hackers. Stuff that matters.
Re:The surprising impact of medium-size texts on PostgreSQL ... by jerrysievert on Tuesday October 20, 2020 @09:44PM (#24844098)
the funny thing is that pg shouldn't need to do a detoasting to be able to query as long as it's jsonb, it's a pretty straightforward iteration - we do the same thing when converting from jsonb to v8 in plv8.
Re:The surprising impact of medium-size texts on PostgreSQL ... by Tomis02 on Wednesday October 21, 2020 @12:46AM (#24844808)
How come? As far as I know if the jsonb data was toasted (too big to fit in 2kb), then in order to query anything back from inside the jsonb you have to de-toast it, by definition.