Re: cluster index on a table

From: Scara Maccai <m_lists(at)yahoo(dot)it>
To: pgsql-performance(at)postgresql(dot)org, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Subject: Re: cluster index on a table
Date: 2009-07-17 06:45:18
Message-ID: 694132.44548.qm@web24607.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> You might be better off
> with a CLUSTER on
> some index. 

I can't: table is too big, can't lock it for minutes; that's why I wanted to cluster it "one day at a time".

Browse pgsql-performance by date

  From Date Subject
Next Message Scara Maccai 2009-07-17 07:22:42 Re: cluster index on a table
Previous Message Scott Marlowe 2009-07-17 06:24:35 Re: Performance comparison between Postgres and Greenplum