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

Поиск
Список
Период
Сортировка
От nobody
Тема Comment 1971 added to page sql-cluster.html of version 7.4
Дата
Msg-id 200501071048.j07AmSFd006416@developer.pgadmin.org
обсуждение исходный текст
Список pgsql-www
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


В списке pgsql-www по дате отправления:

Предыдущее
От: nobody
Дата:
Сообщение: Comment #1969 was rejectd by xzilla
Следующее
От: "Dave Page"
Дата:
Сообщение: Svr2 move and other stuff