Re: cluster index on a table - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: cluster index on a table
Date
Msg-id 4A6051DC0200002500028912@gw.wicourts.gov
Whole thread Raw
In response to Re: cluster index on a table  (Scara Maccai <m_lists@yahoo.it>)
List pgsql-performance
Scara Maccai <m_lists@yahoo.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

pgsql-performance by date:

Previous
From: Scara Maccai
Date:
Subject: Re: cluster index on a table
Next
From: Peter Eisentraut
Date:
Subject: Re: Calling conventions