good advice! > learn about GIN (and GIST) indexes yes, but also learn about the trade-offs and in particular the "pending list". The flush of the pending list

good advice! > learn about GIN (and GIST) indexes yes, but also learn about the trade-offs and in particular the "pending list". The flush of the pending list can be slow, causing timeout, causing the list to not be flushed, causing the next write to trigger flush again and failing in the same way, which means you're having downtime. The default pending list size is weirdly high IMO