Lub tshuab nqus tsev puas puv reindex?
Lub tshuab nqus tsev puas puv reindex?

Video: Lub tshuab nqus tsev puas puv reindex?

Video: Lub tshuab nqus tsev puas puv reindex?
Video: Tshuaj theem vim li cas thiaj tau nqi ?/ Siv kho mob dab tsi?/paris polyphylla use for? 2024, Hlis ntuj nqeg
Anonim

A REINDEX tam sim tom qab a VACUUM FULL tsis muaj nuj nqis vim VACUUM FULL nws tus kheej rebuilds lub indexes. Qhov no yog hais nyob rau hauv 9.4 cov ntaub ntawv nyob rau hauv Recovering Disk Space: Lub TAG NRHO kev xaiv ua tsis shrink indexes; ib ntus REINDEX tseem pom zoo.

Xav txog qhov no, lub tshuab nqus tsev puv ua li cas?

VACUUM FULL . VACUUM FULL sau cov tag nrho cov ntsiab lus ntawm lub rooj rau hauv cov ntaub ntawv disk tshiab thiab tso qhov chaw khib nyiab rov qab rau OS. Qhov no ua rau lub rooj-theem xauv ntawm lub rooj thiab qeeb ceev. VACUUM FULL yuav tsum yuav tsum zam ntawm lub siab load system.

Lub tshuab nqus tsev siv sijhawm ntev npaum li cas? Re: VACUUM FULL siv ntev sij hawm ua kom tiav. hais lus, lub tshuab nqus tsev puv tsis tsim nyog, thiab tag nrho tsis yog ib lub tswv yim zoo. hnov) koj tuaj yeem txo qhov cuam tshuam los ntawm kev tawg txoj haujlwm. txoj hauj lwm yuav tsum xwb coj txog 5 feeb.

Tom qab ntawd, ib tus tuaj yeem nug, puas yog lub tshuab nqus tsev ntsuas lub rooj xauv?

VACUUM analyze ua a VACUUM thiab ces ib SAIB rau txhua tus xaiv rooj . Daim ntawv no qeeb qeeb dua thiab yuav tsum muaj qhov tshwj xeeb xauv ntawm ib leeg rooj thaum nws tab tom ua. Thaum cov npe kev xaiv nyob ib puag ncig los ntawm cov kab lus, cov kev xaiv tuaj yeem sau rau hauv ib qho kev txiav txim.

Autovacuum ntau npaum li cas?

Rau txhua qhov database hauv pawg autovacuum sim pib tus neeg ua haujlwm tshiab ib zaug txhua autovacuum_naptime (default 1 feeb). Nws yuav khiav ntawm feem ntau autovacuum_max_workers (default 3) ib zaug.

Pom zoo: