> I suspect that, since the matched hid's probably aren't sequential, > many of those ~500 product_price_offer_history rows will be far apart > on disk. OMG I was a fool! I'll CLUSTER on a different index and it will be fast, I'm sure. Thanks! L
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных