Re: Slow query on CLUTER -ed tables

From: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
To: Marti Raudsepp <marti(at)juffo(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org, Daniel Fekete <dani(at)shopzeus(dot)com>
Subject: Re: Slow query on CLUTER -ed tables
Date: 2011-03-25 11:56:14
Message-ID: 4D8C82DE.7060601@shopzeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2011-03-25 13:24:55 Re: Why Index is not used
Previous Message Adarsh Sharma 2011-03-25 09:53:24 Re: Why Index is not used