[williamdclt]

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

[ComputerGuru]

Very good point, but also unfortunately requires getting into the internals. If you can tolerate it just use fastupdate off.