On Mon, Mar 4, 2024 at 2:14 PM Chema <chema(at)interneta(dot)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