Skip site navigation (1) Skip section navigation (2)

Re: Equivalent praxis to CLUSTERED INDEX?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Mischa Sandberg <mischa(dot)sandberg(at)telus(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Equivalent praxis to CLUSTERED INDEX?
Date: 2004-08-26 01:16:17
Message-ID: 412D39E1.2040304@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
> I see that PG has a one-shot CLUSTER command, but doesn't support
> continuously-updated clustered indexes.
> 
> What I infer from newsgroup browsing is, such an index is impossible,
> given the MVCC versioning of records (happy to learn I'm wrong).
> 
> I'd be curious to know what other people, who've crossed this same
> bridge from MSSQL or Oracle or Sybase to PG, have devised,
> faced with the same kind of desired performance gain for retrieving
> blocks of rows with the same partial key.

I just run clusterdb each weekend in a cron job...

Chris

In response to

pgsql-performance by date

Next:From: Mark KirkwoodDate: 2004-08-26 04:51:50
Subject: Re: What is the best way to do attribute/values?
Previous:From: Simon RiggsDate: 2004-08-26 00:38:16
Subject: Re: What is the best way to do attribute/values?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group