Обсуждение: Comment 1971 added to page sql-cluster.html of version 7.4

Поиск
Список
Период
Сортировка

Comment 1971 added to page sql-cluster.html of version 7.4

От
nobody
Дата:
Author: Milo Hyson <milo@cyberlifelabs.com>
----
Clustering can correct situations where the query planner chooses the wrong method. We had a two-column table of about
25,000rows with an index on the second column. Even after vacuuming and analyzing, the query planner estimated an index
scanwould take almost 8 times a long as a sequential scan. Forcing index usage proved otherwise. Clustering fixed the
problemand even halved the query times. 
----
Manual page: http://wwwmaster.postgresql.org/docs/7.4/interactive/sql-cluster.html
Reject:      http://wwwmaster.postgresql.org/admin/comments.php?action=reject&id=1971
Edit:        http://wwwmaster.postgresql.org/admin/comment-edit.php?id=1971
Delete:      http://wwwmaster.postgresql.org/admin/comments.php?action=delete&id=1971