VACUUMDB

NAME
SYNOPSIS
DESCRIPTION æè¿°
OPTIONS é项
ENVIRONMENT ç¯å¢
DIAGNOSTICS è¯æ
NOTES 注æ
EXAMPLES ä¾å
SEE ALSO åè§
è¯è
è·

---

NAME

vacuumdb - æ¶éåå¾å¹¶ä¸åæä¸ä¸ªPostgreSQL æ°æ®åº

SYNOPSIS

vacuumdb [ connection-option... ] [ --full | -f ] [ --verbose | -v ] [ --analyze | -z ] [ --table | -t table [ ( column [,...] ) ] ] [ dbname ]

vacuumdb [ connection-options... ] [ --all | -a ] [ --full | -f ] [ --verbose | -v ] [ --analyze | -z ]

DESCRIPTION æè¿°

vacuumdb æ¯ä¸ä¸ªç¨äºæ´ç PostgreSQL æ°æ®åºçå·¥å·ã vacuumdb è¿å°ä¼çæç¨äº PostgreSQL æ¥è¯¢ä¼åå¨çåé¨ç»è®¡æ°æ®ã

vacuumdb æ¯ SQL å½ä»¤ VACUUM [vacuum(7)] çå°è£ã å æ- ¤ï¼ç¨åªç§æ¹æ³æ¸çæ°æ®åºé½æ²¡ä»ä¹ç¹å«çã

OPTIONS é项

vacuumdb æ¥åä¸åå½ä»¤è¡åæ°ï¼

	-a
	--all

æ¸çæææ°æ®åºã

[-d] dbname
[--dbname] dbname

声æè¦è¢«æ¸çæåæçæ°æ®åºå称ã å¦æ没æ声æè¿ä¸ªåæ°å¹¶ä¸æ²¡æä½¿ç¨ -aï¼æ --allï¼ï¼ é£ä¹ä»ç¯å¢åé PGDATABASE é读åæ°æ®åºåã å¦æé£ä¸ªä¹æ²¡æ设置ï¼å使ç¨è¿æ¥çç¨æ·åã

	-e
	--echo

åæ¾ vacuumdb çæçæ¥è¯¢å¹¶ä¸æå®åéå°æå¡å¨ã

	-f
	--full

æ§è¡"å®å¨"æ¸çï¼

-q

--quiet

ä¸æ¾ç¤ºååºã

-t table [ (column [,...]) ]
--table table [ (column [,...]) ]

åªæ¯æ¸çæåæ tableã å段å称åªæ¯å¨ä¸ --analyze é项èå使ç¨æ¶æéè¦å£°æã

Tip: æ示: å¦æ你声æäºè¦æ¸ççå段ï¼ä½ å¯è½ä¸å¾ä¸å¨ shell ä¸éé¸åæ¬å¼§ï¼è§ä¸é¢çä¾åï¼ã

-v

--verbose

å¨å¤çè¿ç¨ä¸æå°è¯¦ç»ä¿¡æ¯ã

-z

--analyze

计ç®ç¨äºä¼åå¨ç该æ°æ®åºçç»è®¡å¼ã

vacuumdb è¿æ¥åä¸é¢çå½ä»¤è¡åæ°ç¨äºèæ¥åæ°ï¼
-h host
--host host

声æè¿è¡æå¡å¨çæºå¨ç主æºåã å¦æ主æºå以ææå¼å¤´ï¼åå®è¢«ç¨åå° Unix åå¥æ¥åçè·¯å¾ã

-p port
--port port

声ææå¡å¨å¨ä¾¦å¬èæ¥ç TCP 端å£å·æä¸ä¸ªæ¬å°ç Unix åå¥æ¥åæ件å¥æã

-U username
--username username

è¿è¡èæ¥çç¨æ·åã

-W

--password

强å¶å£ä»¤è¾å¥æ示ã

ENVIRONMENT ç¯å¢

PGDATABASE

	PGHOST
	PGPORT
	PGUSER

缺çè¿æ¥åæ°

DIAGNOSTICS è¯æ

å¦æåºå·®éäºãåé VACUUM [vacuum(7)] å psql(1) è·åå³äºé误信æ¯åå¯è½é®é¢ç详ç»æè¿°ã æ°æ®åºæå¡å¨å¿é¡»å¨ç®æ ä¸»æºä¸è¿è¡ãåæ¶ï¼åç«¯åº libpq 使ç¨çä»»ä½ç¼ºçè¿æ¥è®¾ç½®åç¯å¢åéé½éç¨ã

NOTES 注æ

vacuumdb å¯è½éè¦ä¸ PostgreSQL æå¡å¨è¿æ¥è¥å¹²æ¬¡ï¼æ¯æ¬¡é½è¯¢é®å£ä»¤ãå¨è¿ç§æåµä¸ï¼è®¾ç«ä¸ä¸ª $HOME/.pgpass æ¯æ¯è¾æ¹ä¾¿çãåé Section 27.11 è·åæ´å¤ä¿¡æ¯ã

EXAMPLES ä¾å

æ´çæ°æ®åº testï¼

$ vacuumdb test

为ä¼åå¨æ¸çååæä¸ä¸ªå为 bigdb çæ°æ®åºï¼

$ vacuumdb --analyze bigdb

为æ¸çæ°æ®åºxyzzyé表 fooï¼ å¹¶ä¸ä¸ºä¼åå¨åæå barï¼

$ vacuumdb --analyze --verbose --table ’foo(bar)’ xyzzy

SEE ALSO åè§

VACUUM [vacuum(7)]

è¯è

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

è·

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

---