Hello,
I am trying to implement an efficient "like" over a text[]. I see a lot of
people have tried before me and I learnt a lot through the forums. The results
of my search is that a query like the following is optimal:
select count(*)
from claims
where (select count(*)
from unnest
Hi,
I tried pg_repack on the new server with no luck, so I've decided to move
back to the old server to discard:
1. performance decrease due to server raw characteristics
2. performance decrease due to network latencies
I've seen no improvement whatsoever. Could the issue be due to one of,
