On Mon, Mar 4, 2024 at 2:14 PM Chema <ch...@interneta.org> wrote:

> There's one JSON column in each table with a couple fields, and a column
> with long texts  in Items.

and earlier indicated the query was:

> Select * from tenders inner join items


You do not want to do a "select star" on both tables unless you 100% need
every single column and plan to actively do something with it. Especially
true for large text and json columns. Also, use jsonb not json.

Cheers,
Greg

Reply via email to