Re: cluster index on a table

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Scara Maccai" <m_lists(at)yahoo(dot)it>
Cc: "Greg Stark" <greg(dot)stark(at)enterprisedb(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: cluster index on a table
Date: 2009-07-17 15:26:36
Message-ID: 4A6051DC0200002500028912@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Scara Maccai <m_lists(at)yahoo(dot)it> wrote:

>> Be sure to include an ORDER BY clause.

> Isn't it going to be much slower?

It might be; you'd have to test to know for sure.

> The important thing is that most of the records are stored "close"
> enough one to the other in the right order.

Then, yeah, it might not be worth the cost of sorting.

-Kevin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Peter Eisentraut 2009-07-17 15:32:12 Re: Calling conventions
Previous Message Scara Maccai 2009-07-17 14:36:34 Re: cluster index on a table