CLUSTER

中文man手册

目录

NAME CLUSTER
SYNOPSIS .sp .nf CLUSTER
DESCRIPTION 描述
PARAMETERS 参数
NOTES 注意
EXAMPLES 例子
COMPATIBILITY 兼容性
SEE ALSO 参见
译者
跋

CLUSTER

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES æ³¨æ
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·

NAME

CLUSTER - æ ¹æ®ä¸ä¸ªç´¢å¼å¯¹æä¸ªè¡¨éç°

SYNOPSIS

CLUSTER indexname ON tablename
CLUSTER tablename
CLUSTER

DESCRIPTION æè¿°

CLUSTER æç¤ºPostgreSQL åºäºç´¢å¼ indexname çåº¦éå¯¹è¡¨ table è¿è¡å- å¨å»ºç°ãç´¢å¼å¿é¡»å·²ç»å¨è¡¨ tablename. ä¸å®ä¹ã

å½å¯¹ä¸ä¸ªè¡¨å»ºç°åï¼è¯¥è¡¨çç©çåå¨å°åºäºç´¢å¼ä¿¡æ¯è¿è¡ã å»ºç°æ¯ä¸æ¬¡æ§æä½ï¼ä¹å°±æ¯è¯´ï¼å½è¡¨éåè¢«æ´æ°åï¼æ¹åçåå®¹ä¸ä¼å»ºç°ã ä¹å°±æ¯è¯´ï¼ç³»ç»ä¸ä¼è¯å¾æç§ç´¢å¼é¡ºåºå¯¹æ´æ°è¿çè®°å½éæ°å»ºç°ã å¦æéè¦ï¼å¯ä»¥éè¿å¨ææ§å°æå·¥æ§è¡è¯¥å½ä»¤çæ¹æ³éå»ºç°ã

å¨å¯¹ä¸ä¸ªè¡¨å»ºç°ä¹åï¼PostgreSQL ä¼è®°å¿å¨åªä¸ªç´¢å¼ä¸å»ºç«çç°ã CLUSTER tablename çå½¢å¼å°±å¨è¡¨ä»¥åå»ºç°çåä¸ä¸ªç´¢å¼ä¸å»ºç°ã

æ²¡æä»»ä½åæ°ç CLUSTER å°å¯¼è´å½åæ°æ®åºéææè°ç¨å®çç¨æ·ææçè¡¨é½è¢«å»ºç°ã ï¼ç»ä¸ä¼å¯¹ä¸åæ¬è¿æ¥çè¡¨å»ºç°ãï¼è¿ç§å½¢å¼ç CLUSTER ä¸è½å¨ä¸ä¸ªäºå¡æèå½æ°éé¢è°ç¨ã

å¨å¯¹ä¸ä¸ªè¡¨è¿è¡å»ºç°çæ¶åï¼åå¨å¶ä¸è¯·æ±ä¸ä¸ª ACCESS EXCLUSIVE éã è¿æ ·å°±é¿åäºå¨ CLUSTER å®æä¹åæ§è¡ä»»ä½å¶ä»çæ°æ®åºæä½ï¼åæ¬è¯»åï¼ã åé Section 12.3 è·åæå³æ°æ®åºéå®çæ´å¤ä¿¡æ¯ã

PARAMETERS åæ°

indexname

ä¸ä¸ªç´¢å¼åç§°ã

tablename

åå¤å»ºç°çè¡¨çåç§°ï¼å¯è½ææ¨¡å¼ä¿®é¥°ï¼ã

NOTES æ³¨æ

å¦æä½ åªæ¯éæºçè®¿é®è¡¨ä¸çè¡ï¼ é£ä¹å¨å è¡¨ä¸çæ°æ®çå®éå- å¨é¡ºåºæ¯æ å³ç´§è¦çã ä½æ¯ï¼å¦æä½ å¯¹æäºæ°æ®çè®¿é®å¤äºå¶ä»æ°æ®ï¼ èä¸æä¸ä¸ªç´¢å¼å°è¿äºæ°æ®åç»ï¼é£ä½ å°±å°ä»ä½¿ç¨ CLUSTER ä¸è·çã å¦æä½ ä»ä¸ä¸ªè¡¨ä¸è¯·æ±ä¸å®ç´¢å¼èå´çå¼ï¼ æèæ¯ä¸ä¸ªç´¢å¼è¿çå¼å¯¹åºå¤è¡ï¼ CLUSTER ä¹ä¼æå©äºåºç¨ï¼ å ä¸ºå¦æç´¢å¼æ è¯åºç¬¬ä¸å¹éè¡æå¨çå å- å¨é¡µï¼ææå¶ä»è¡ä¹å¯è½å·²ç»å¨åä¸å åå¨é¡µéäºï¼ è¿æ ·ä¾¿èçäºç£çè®¿é®çæ¶é´ï¼å éäºæ¥è¯¢ã

å¨è¿ä¸ªå»ºç°çæä½è¿ç¨ä¸- ï¼ç³»ç»ååå»ºä¸ä¸ªæç§ç´¢å¼é¡ºåºå»ºç«çè¡¨çä¸´æ¶æ·è´ã åæ¶ä¹å»ºç«è¡¨ä¸çæ¯ä¸ªç´¢å¼çä¸´æ¶æ·è´ãå æ- ¤ï¼ä½ éè¦ç£çä¸æè¶³å¤çå©ä½ç©ºé´ï¼ è³å°æ¯è¡¨å¤§å°åç´¢å¼å¤§å°çåã

å ä¸º CLUSTER è®°å¿å»ºç°ä¿¡æ¯ï¼æä»¬å¯ä»¥å¨ç¬¬ä¸æ¬¡çæ¶åæå·¥å¯¹è¡¨è¿è¡å»ºç°ï¼ ç¶åè®¾ç½®ä¸ä¸ªç±»ä¼¼ VACUUM çæ¶é´ï¼ è¿æ ·æä»¬å°±å¯ä»¥å¨æå°èªå¨å¯¹è¡¨è¿è¡å»ºç°äºã

å ä¸ºè§åå¨è®°å½çæå³è¡¨çæåºçç»è®¡ï¼æä»¥æä»¬å»ºè®®å¨æ°è¿å»ºç°çè¡¨ä¸è¿è¡ ANALYZEã å¦åï¼è§åå¨å¯è½ä¼éæ©å¾å·®å²çæ¥è¯¢è§åã

è¿æä¸ç§å»ºç°çæ¹æ³ã CLUSTER å½ä»¤å°åè¡¨æä½ å£°æçç´¢å¼éæ°æåã è¿ä¸ªå¨ä½å¨æä½å¤§è¡¨æ¶å¯è½ä¼å¾æ¢ï¼ å ä¸ºæ¯ä¸è¡é½ä»å å- å¨é¡µéæç´¢å¼é¡ºåºååºï¼å¦æåå¨é¡µè¡¨æ²¡ææåºï¼ æ´ä¸ªè¡¨æ¯éæºå- æ¾å¨åä¸ªé¡µé¢çï¼å èç§»å¨çæ¯ä¸è¡é½è¦è¿è¡ä¸æ¬¡ç£çé¡µé¢æä½ã PostgreSQL æä¸ä¸ªç¼å²ï¼ ä½ä¸ä¸ªå¤§è¡¨çä¸»ä½æ¯ä¸å¯è½é½æ¾å°ç¼å²å»çã å¦å¤ä¸ç§å¯¹è¡¨å»ºç°çæ¹æ³æ¯

CREATE TABLE newtable AS
SELECT columnlist FROM table ORDER BY columnlist;

è¿ä¸ªç¨æ³ä½¿ç¨PostgreSQL æåºçä»£ç ORDER BY æ¥åå»ºä¸ä¸ªéè¦çé¡ºåºï¼å¨å¯¹æªæåºçæ°æ®æä½æ¶éå¸¸éåº¦æ¯ç´¢å¼æ«æå¿«å¾å¤ã ç¶åä½ å¯ä»¥å é¤æ§è¡¨ï¼ç¨ ALTER TABLE ... RENAMEå° newtable æ¹ææ§è¡¨åï¼ å¹¶ä¸éå»ºè¯¥è¡¨ææç´¢å¼ãä½æ¯ï¼è¿ä¸ªæ¹æ³ä¸ä¿ç OIDï¼çº¦æï¼å¤é®å³ç³»ï¼ èµäºçæéï¼ä»¥åè¡¨çå¶å®éå±çå±æ§ ---- ææè¿äºå±æ§é½å¿é¡»æå·¥éå»ºã

EXAMPLES ä¾å

ä»¥éåç emp_ind å±æ§å¯¹employeeså³ç³»å»ºç°ã

CLUSTER emp_ind ON emp;

ä½¿ç¨ä»¥åç¨è¿çåä¸ä¸ªç´¢å¼å¯¹employeesè¡¨è¿è¡å»ºç°ï¼

CLUSTER emp;

å¯¹ä»¥åå»ºè¿ç°çææè¡¨è¿è¡å»ºç°ï¼

CLUSTER;

COMPATIBILITY å¼å®¹æ§

å¨ SQL æ åéæ²¡æ CLUSTER è¯å¥ã

SEE ALSO åè§

clusterdb [clusterdb(1)]

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æåé¡µè®¡åæä¾ã
ä¸æ man æåé¡µè®¡åï¼https://github.com/man-pages-zh/manpages-zh

↑