PostgreSQL ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ. ืžืขืœื“ื•ื ื’ ืคื•ืŸ ืจื™ืฉืึทืคึผืข, ืึท ื ื•ืฆืŸ ืคึฟืึทืจ ืžื™ื’ืจื™ื™ื˜ื™ื ื’ ืฆื• ืึท ื ื™ื™ึทืข ืกื˜ืฉืขืžืึท ืึธืŸ ืกื˜ืึธืคึผืคึผื™ื ื’ ืึทืจื‘ืขื˜

ืงืขืจืขืงื˜ื™ื•ื• ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงื•ื ื’ืขืŸ ื–ืขื ืขืŸ ื“ื–ืฉืขื ืขืจื™ื™ื˜ืึทื“ ืคึฟืึทืจ ืึทืœืข ืฉื˜ื™ืฆื˜ ืฆื•ื•ื™ื™ื’ืŸ ืคื•ืŸ PostgreSQL: 14.2, 13.6, 12.10, 11.15 ืื•ืŸ 10.20, ื•ื•ืึธืก ืจื™ื›ื˜ื™ืง 55 ืขืจืจืึธืจืก ื™ื™ื“ืขื ืึทืคื™ื™ื“ ืื™ืŸ ื“ื™ ืœืขืฆื˜ืข ื“ืจื™ื™ ื—ื“ืฉื™ื. ืฆื•ื•ื™ืฉืŸ ืื ื“ืขืจืข ื–ืื›ืŸ, ืžื™ืจ ื”ืึธื‘ืŸ ืคืึทืจืคืขืกื˜ื™ืงื˜ ืคึผืจืึธื‘ืœืขืžืก ื•ื•ืึธืก, ืื™ืŸ ื–ืขืœื˜ืŸ ืฆื•ืฉื˜ืื ื“ืŸ, ื’ืขืคึฟื™ืจื˜ ืฆื• ืื™ื ื“ืขืงืก ืงืึธืจื•ืคึผืฆื™ืข ื•ื•ืขืŸ ื˜ืฉืึทื ื’ื™ื ื’ ื”ื™ื™ืก (ื”ื•ื™ืคืŸ-ื‘ืœื•ื™ื– ื˜ื•ืคึผืœืข) ืงื™ื™ื˜ืŸ ื‘ืขืฉืึทืก ืึท ื•ื•ืึทืงื•ื•ื ืึธืคึผืขืจืึทืฆื™ืข ืึธื“ืขืจ ื•ื•ืขืŸ ืคึผืขืจืคืึธืจืžื™ื ื’ ืึท REINDEX ืงืึทื ืงืขืจืึทื ื˜ืœื™ ืึธืคึผืขืจืึทืฆื™ืข ืื•ื™ืฃ ื™ื ื“ืขืงืกื™ื– ืื•ื™ืฃ ื˜ื™ืฉืŸ ื•ื•ืึธืก ื ื•ืฆืŸ ื“ื™ TOAST ืกื˜ืึธืจื™ื“ื–ืฉ ืžืขืงืึทื ื™ื–ืึทื.

ืคืึทืจืคืขืกื˜ื™ืงื˜ ืงืจืึทืฉื™ื– ื•ื•ืขืŸ ืขืงืกืึทืงื™ื•ื˜ื™ื ื’ ืึทืœื˜ืขืจ ืกื˜ืึทื˜ื™ืกื˜ื™ืง ืื•ืŸ ื•ื•ืขืŸ ืจื™ื˜ืจื™ื•ื•ื™ื ื’ ื“ืึทื˜ืŸ ืžื™ื˜ ืžื•ืœื˜ื™ืจื™ื™ื ื“ื–ืฉ ื˜ื™ื™ืคึผืก. ื‘ืึทื’ื– ืื™ืŸ ื“ื™ ืึธื ืคึฟืจืขื’ ืคึผืœืึทื ืขืจ ื•ื•ืึธืก ื’ืขืคึฟื™ืจื˜ ืคืึทืœืฉ ืจืขื–ื•ืœื˜ืึทื˜ืŸ ื–ืขื ืขืŸ ืคืึทืจืคืขืกื˜ื™ืงื˜. ืคืึทืจืคืขืกื˜ื™ืงื˜ ื–ื›ึผืจื•ืŸ ืœื™ืงืก ื•ื•ืขืŸ ืึทืคึผื“ื™ื™ื˜ื™ื ื’ ื™ื ื“ืขืงืกื™ื– ื ื™ืฆืŸ ืื•ื™ืกื“ืจื•ืงืŸ ืื•ืŸ ื•ื•ืขืŸ ืื™ืจ ื“ื•ืจื›ืคื™ืจืŸ ืึท REASSIGN OWNED BY ืึธืคึผืขืจืึทืฆื™ืข ืื•ื™ืฃ ืึท ื’ืจื•ื™ืก ื ื•ืžืขืจ ืคื•ืŸ ืึทื‘ื“ื–ืฉืขืงืฅ. ื“ื™ ืงืึทื ืกื˜ืจืึทืงืฉืึทืŸ ืคื•ืŸ ืึทื•ื•ืึทื ืกื™ืจื˜ืข ืกื˜ืึทื˜ื™ืกื˜ื™ืง ืคึฟืึทืจ ืกืขื’ืžืขื ื˜ืขื“ ื˜ื™ืฉืŸ ืื™ื– ืฆื•ื’ืขืฉื˜ืขืœื˜.

ืื™ืŸ ื“ืขืจืฆื•, ืžื™ืจ ืงืขื ืขืŸ ื˜ืึธืŸ ื“ื™ ืžืขืœื“ื•ื ื’ ืคื•ืŸ ื“ื™ ืจืขืฉื™ื™ืคึผ ื ื•ืฆืŸ, ื•ื•ืึธืก ืึทืœืึทื•ื– ืื™ืจ ืฆื• ื“ื•ืจื›ืคื™ืจืŸ ืงืึธืžืคึผืœืขืงืก ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงื•ื ื’ืขืŸ ืฆื• ื“ื™ ื“ืึทื˜ืŸ ืกื˜ืฉืขืžืึท ืื™ืŸ PostgreSQL ืึธืŸ ืกื˜ืึธืคึผืคึผื™ื ื’ ืึทืจื‘ืขื˜, ื•ื•ืึธืก ืื•ื ื˜ืขืจ ื ืึธืจืžืึทืœ ื˜ื ืึธื™ื ื“ืึทืจืคืŸ ืžืึทื ื•ืึทืœ ืขื ื“ืขืจื•ื ื’ืขืŸ ืื•ืŸ ืฆื™ื™ื˜ื•ื•ื™ื™ืœื™ื’ืข ืฉืึทื˜ื“ืึทื•ืŸ ืคื•ืŸ ืกืขืจื•ื•ื™ืกืขืก ื ื™ืฆืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก. ื“ื™ ื ื•ืฆืŸ ืžืื›ื˜ ืขืก ืžืขื’ืœืขืš ืฆื• ื‘ืึทืฉื˜ื™ืžืขืŸ ืคื•ืŸ ื“ื™ ืึทืœื˜ ื“ืึทื˜ืŸ ืกื›ืขืžืข ืฆื• ื“ื™ ื ื™ื™ึทืข ืึธืŸ ืœืึทื ื’ ื‘ืœืึทืงื™ื ื’ ืื•ืŸ ืึธืŸ ื™ื ื˜ืขืจืึทืคึผื˜ื™ื ื’ ื“ื™ ื‘ืขื˜ืŸ ืคึผืจืึทืกืขืกื™ื ื’ ืฆื™ืงืœ. ื“ื™ ื ื•ืฆืŸ ืื•ื™ื˜ืึธืžืึทื˜ื™ืฉ ืงืจื™ื™ื™ืฅ ื˜ื™ืฉ ืงื•ืงืŸ ืžื™ื˜ ื•ื•ืึธืก ืึทืคึผืœืึทืงื™ื™ืฉืึทื ื– ืคืึธืจื–ืขืฆืŸ ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ื“ื™ ืžื™ื™ื’ืจื™ื™ืฉืึทืŸ ืคื•ืŸ ื“ืึทื˜ืŸ ืกื˜ืฉืขืžืึท, ืื•ืŸ ืื•ื™ืš ืงืึทื ืคื™ื’ื™ืขืจ ื˜ืจื™ื’ืขืจื– ื•ื•ืึธืก ืื™ื‘ืขืจื–ืขืฆืŸ ืึทืคึผืขืจื™ื™ืฉืึทื ื– ืคื•ืŸ ืึทื“ื™ื ื’ ืื•ืŸ ื•ื™ืกืžืขืงืŸ ื“ืึทื˜ืŸ ืฆื•ื•ื™ืฉืŸ ืึทืœื˜ ืื•ืŸ ื ื™ื™ึท ืกื˜ืฉืขืžืึทืก.

ืื–ื•ื™, ื•ื•ืขืŸ ืื™ืจ ื ื•ืฆืŸ ืจื™ืฉืึทืคึผืข ื‘ืขืฉืึทืก ืžื™ื™ื’ืจื™ื™ืฉืึทืŸ, ื“ื™ ืึทืœื˜ ืื•ืŸ ื ื™ื™ึท ืกื˜ืฉืขืžืึท ื‘ืœื™ื™ื‘ืŸ ื‘ืืจืขื›ื˜ื™ื’ื˜ ืื™ืŸ ื“ืขืจ ื–ืขืœื‘ื™ืงืขืจ ืฆื™ื™ื˜ ืื•ืŸ ืึทืคึผืœืึทืงื™ื™ืฉืึทื ื– ืงืขื ืขืŸ ื–ื™ื™ืŸ ื‘ื™ืกืœืขื›ื•ื•ื™ื™ึทื– ื˜ืจืึทื ืกืคืขืจื“ ืฆื• ื“ื™ ื ื™ื™ึทืข ืกื˜ืฉืขืžืึท ืึธืŸ ืกื˜ืึธืคึผืคึผื™ื ื’ ืึทืจื‘ืขื˜ (ืื™ืŸ ื’ืจื•ื™ืก ื™ื ืคืจืึทืกื˜ืจืึทืงื˜ืฉืขืจ, ื”ืึทื ื“ืœืขืจืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ื‘ื™ืกืœืขื›ื•ื•ื™ื™ึทื– ืจื™ืคึผืœื™ื™ืกื˜ ืคื•ืŸ ืึทืœื˜ ืฆื• ื ื™ื™ึท). ืึทืžืึธืœ ื“ื™ ืžื™ื™ื’ืจื™ื™ืฉืึทืŸ ืคื•ืŸ ืึทืคึผืœืึทืงื™ื™ืฉืึทื ื– ืฆื• ื“ื™ ื ื™ื™ึทืข ืกื˜ืฉืขืžืึท ืื™ื– ื’ืขืขื ื“ื™ืงื˜, ื“ื™ ืงื•ืงืŸ ืื•ืŸ ื˜ืจื™ื’ืขืจื– ื‘ืืฉืืคืŸ ืฆื• ื”ืึทืœื˜ืŸ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื“ื™ ืึทืœื˜ ืกื˜ืฉืขืžืึท ื–ืขื ืขืŸ ืื•ื™ืกื’ืขืžืขืงื˜. ืื•ื™ื‘ ืคึผืจืึธื‘ืœืขืžืก ืžื™ื˜ ืึทืคึผืœืึทืงื™ื™ืฉืึทื ื– ื–ืขื ืขืŸ ื™ื™ื“ืขื ืึทืคื™ื™ื“ ื‘ืขืฉืึทืก ืžื™ื™ื’ืจื™ื™ืฉืึทืŸ, ืื™ืจ ืงืขื ืขืŸ ืคืึทืจืงืขืจื˜ ื“ื™ ืกื›ืขืžืข ื˜ื•ื™ืฉืŸ ืื•ืŸ ืฆื•ืจื™ืงืงื•ืžืขืŸ ืฆื• ื“ื™ ืึทืœื˜ ืฉื˜ืึทื˜.

ืžืงื•ืจ: opennet.ru

ืœื™ื™ื’ืŸ ืึท ื‘ืึทืžืขืจืงื•ื ื’