pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Subject: Re: cluster on conditional index?
Date: Wed, 15 Aug 2012 14:05:18 -0700
Message-ID: <502C0F0E.2010503@agliodbs.com> (raw)
In-Reply-To: <CALxYTP4WM2BGqkLKq04Tt+BX2D5gf43r8AEtQzhAnvTiBnhdDg@mail.gmail.com>
References: <CALxYTP4vNQ+_rA7eHS+-wCYs7GaQdyaFoJb7g_UzvBt1ou2Eng@mail.gmail.com>
	<CAMkU=1yB0C7pZzk9tM2mAUB8RWHxnpoVLn28ZQ_uSE__uTZAcg@mail.gmail.com>
	<20120814172910.GP27500@aart.rice.edu>
	<CALxYTP4WM2BGqkLKq04Tt+BX2D5gf43r8AEtQzhAnvTiBnhdDg@mail.gmail.com>


> That actually makes sense to me. Cluster the rows covered by that
> index, let the rest fall where they may. I'm typically only accessing
> the rows covered by that index, so I'd get the benefit of the cluster
> command but wouldn't have to spend cycles doing the cluster for rows I
> don't care about.

Sure, that's a feature request though.  And thinking about it, I'm
willing to bet that it's far harder to implement than it sounds.

In the meantime, you could ad-hoc this by splitting the table into two
partitions and clustering one of the two partitions.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com




view thread (9+ messages)  latest in thread

Message-ID: <502C0F0E.2010503@agliodbs.com>
Permalink:  ../502C0F0E.2010503@agliodbs.com/
Also on:    postgresql.org/message-id/502C0F0E.2010503@agliodbs.com

 · 

reply
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: josh@agliodbs.com
  Subject: Re: cluster on conditional index?
  In-Reply-To: <502C0F0E.2010503@agliodbs.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