First in short - clustering on an index forces the physical ordering of the data to be the same as the index order of the index chosen. Since you can have only one physical order of a table, you can have only one clustered index per table and should carefully pick which index you will use to cluster on or if you even want to cluster. Unlike Microsoft SQL Server, clustering on an index in PostgreSQL does not maintain that order. You have to reapply the CLUSTER process to maintain the order. Clustering helps by reducing page seeks. Once an index search is done and found, pulling out the data on the same page is vastly faster since once you find the start point all successive data nearby is easy picking.
M. Ackermann, and J. Blömer. Proceedings of the 20th Annual ACM-SIAM Symposium on Discrete Algorithms (SODA '09), page 1088--1097. Society for Industrial and Applied Mathematics (SIAM), (2009)
R. Agrawal, J. Gehrke, D. Gunopulos, and P. Raghavan. Proceedings of the ACM SIGMOD Int'l Conference on Management of Data, Seattle, Washington, page 94--105. ACM Press, (June 1998)
R. Agrawal, J. Gehrke, D. Gunopulos, and P. Raghavan. SIGMOD '98: Proceedings of the 1998 ACM SIGMOD International Conference on Management of Data, page 94-105. ACM Press, (1998)
M. Ankerst, M. Breunig, H. Kriegel, and J. Sander. International Conference on Management of Data and Symposium on Principles of Database Systems Philadelphia (SIGMOD/PODS 1999), PA, USA - May 31 - June 03, 1999, page 49-60. New York, NY, USA, ACM, (1999)
D. Arthur, and S. Vassilvitskii. SODA '07: Proceedings of the eighteenth annual ACM-SIAM symposium on Discrete algorithms, page 1027--1035. Philadelphia, PA, USA, Society for Industrial and Applied Mathematics, (2007)
D. Arthur, and S. Vassilvitskii. SODA '07: Proceedings of the eighteenth annual ACM-SIAM symposium on Discrete algorithms, page 1027--1035. Philadelphia, PA, USA, Society for Industrial and Applied Mathematics, (2007)
C. Brooks, and N. Montanez. WWW '06: Proceedings of the 15th international conference on World Wide Web, page 625--632. New York, NY, USA, ACM Press, (2006)