Emebere ntọhapụ nke PostgreSQL DBMS 14.4, nke na-ewepụ nsogbu siri ike nke, n'okpuru ọnọdụ ụfọdụ, na-eduga na nrụrụ data na-adịghị ahụ anya na ndeksi mgbe ị na-eme iwu "CREATE INDEX CONCURRENTLY" na "REINDEX CONCURRENTLY". N'ime ndenye aha emepụtara site na iji iwu akọwapụtara, enwere ike ọ gaghị eburu n'uche ụfọdụ ndekọ, nke ga-eduga n'ahịrị efu mgbe ị na-eme ajụjụ SELECT metụtara ndenye nsogbu.
Iji chọpụta ma e mebiela ndepụta osisi B-osisi, ị nwere ike iji iwu "pg_amcheck -heapallindexed db_name". Ọ bụrụ na achọpụtara mperi ma ọ bụ iwu “CREATE INDEX CONCURRENTLY” na “REINDEX CONCURRENTLY” na ewepụtara ndị gara aga na ụdị ndeksi ndị ọzọ (GiST, GIN, wdg), mgbe emelitechara na ụdị 14.4, a na-atụ aro ka ịmegharịgharị site na iji akara ngosi. “reindexdb —niile” uru ma ọ bụ iwu “REINDEX CONCURRENTLY index_name."
Nsogbu a na-emetụta naanị ngalaba 14.x, nke gụnyere njikarịcha nke na-ewepu ụfọdụ azụmahịa metụtara mmezu nke "CREATE INDEX CONCURRENTLY" na "REINDEX CONCURRENTLY" mgbe ị na-arụ ọrụ VACUUM. N'ihi njikarịcha ndị a, ndenye aha emepụtara n'ụdị ọnọdụ adịghị etinye ụfọdụ tuples na ebe nchekwa kpokọtara nke emelitere ma ọ bụ gbachie n'oge imepụta ndeksi.
isi: opennet.ru