[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: cluster on conditional index?

> 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.

Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Home]     [Yosemite]

Powered by Linux