From: Laszlo Nagy <gandalf@shopzeus.com>
To: Marti Raudsepp <marti@juffo.org>
Cc: pgsql-performance@postgresql.org, Daniel Fekete <dani@shopzeus.com>
Subject: Re: Slow query on CLUTER -ed tables
Date: Fri, 25 Mar 2011 12:56:14 +0100
Message-ID: <4D8C82DE.7060601@shopzeus.com> (raw)
In-Reply-To: <AANLkTim5Cp5_LjXDyQNrikcjdNv03uGJon3OzQrd5bGS@mail.gmail.com>
References: <4D8A581C.6040505@shopzeus.com>
<AANLkTim5Cp5_LjXDyQNrikcjdNv03uGJon3OzQrd5bGS@mail.gmail.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gandalf@shopzeus.com, marti@juffo.org, dani@shopzeus.com
Subject: Re: Slow query on CLUTER -ed tables
In-Reply-To: <4D8C82DE.7060601@shopzeus.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox