Hi I come from a MS-SQL background and I'm trying to get some clarity on indexes in Postgres. If anyone can help with the following questions it would be much appreciated: 1. When creating a primary key contraint on a table, is an equivalent index automatically created for you, or would I have to create an index manually? 2. How do I create a clustered index in postgres? Thanks Craig ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly