且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

PostgreSQL中的集群和非集群索引

更新时间:2023-11-03 10:09:04


我的问题:我可以使用什么类型的索引代替集群和非集群PostgreSQL中的ustered索引,它与集群索引和非集群索引的作用相同吗?

My Question: What type of index I can use instead of clustered and non clustered index in PostgreSQL,Which does the same job as clustered and non clustered indexes does?

PostgreSQL没有集群的概念索引。相反,所有表都是堆表,所有索引都是非聚簇索引。

PostgreSQL doesn't have the concept of clustered indexes at all. Instead, all tables are heap tables and all indexes are non-clustered indexes.

只需在创建聚簇索引时创建非聚集索引。

Just create a non-clustered index when you'd usually create a clustered index.

更多详情:

  • http://use-the-index-luke.com/sql/clustering/index-organized-clustered-index
    You might want to read the whole chapter to get proper understanding of these concepts.