Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow query on CLUTER -ed tables - Mailing list pgsql-performance

From Laszlo Nagy
Subject Re: Slow query on CLUTER -ed tables
Date
Msg-id 4D8C82DE.7060601@shopzeus.com
Whole thread Raw
In response to Re: Slow query on CLUTER -ed tables  (Marti Raudsepp <marti@juffo.org>)
List pgsql-performance
Tree view 
> 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:

Previous
From: Adarsh Sharma
Date:
Subject: Re: Why Index is not used
Next
From: Shaun Thomas
Date:
Subject: Re: Why Index is not used