ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ื™ืึทื ื“ืขืงืก ืก ืฆื•ืฉื˜ื™ื™ึทืขืจ ืฆื• ื“ื™ ืคืืœื’ืขื ื“ืข ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ื•ื•ืขื˜ ื–ื™ื™ืŸ ืจื™ื•ื•ื™ื•ื“.

  • ืงืœื™ืงืงื›ืึทื•ืก
  • ืึธื“ื™ืกืกื™ื™
  • ืึธืคึผื–ื•ืš ืฆื• ืึท ืคื•ื ื˜ ืื™ืŸ ืฆื™ื™ื˜ (WAL-G)
  • PostgreSQL (ืึทืจื™ื™ึทื ื’ืขืจืขื›ื ื˜ ืœืึธื’ืขืจืจืึธืจืก, Amcheck, Heapcheck)
  • ื’ืจื™ื ืคึผืœื•ื

ื•ื™ื“ืื•:

ื”ืขืœื ื•ื•ืขืœื˜! ืžื™ื™ึทืŸ ื ืึธืžืขืŸ ืื™ื– ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ. ืื•ืŸ ื•ื•ืึธืก ืื™ืš ื˜ืึธืŸ ื‘ื™ื™ Yandex.Cloud ืื™ื– ืึทื ื˜ื•ื•ื™ืงืœืขืŸ ืึธืคึฟืŸ ืจื™ืœื™ื™ืฉืึทื ืึทืœ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ืื™ืŸ ื“ื™ ืื™ื ื˜ืขืจืขืกืŸ ืคื•ืŸ Yandex.Cloud ืื•ืŸ Yandex.Cloud ืงืœื™ื™ืึทื ืฅ.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

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

ืึธื‘ืขืจ! ื•ื•ืึธืก ืื™ื– ื“ื™ ืžื™ื™ึทืœืข ืคื•ืŸ โ€‹โ€‹ืขืคืขื ืขืŸ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–? ื“ืขืจ ืคืึทืงื˜ ืื™ื– ืึทื– ืื™ืจ ื”ืึธื‘ืŸ ืึท ื˜ืขืึธืจืขื˜ื™ืฉ ื’ืขืœืขื’ื ื”ื™ื™ื˜ ืฆื• ื”ืึทื ื“ืœืขืŸ ืžื™ื˜ ืงื™ื™ืŸ ืคึผืจืึธื‘ืœืขื. ืื™ืจ ื”ืึธื‘ืŸ ื“ื™ ืžืงื•ืจ ืงืึธื“, ืื™ืจ ื”ืึธื‘ืŸ ืคึผืจืึธื’ืจืึทืžืžื™ื ื’ ื•ื•ื™ืกืŸ. ืžื™ืจ ืคืึทืจื‘ื™ื ื“ืŸ ืขืก ืื•ืŸ ืขืก ืึทืจื‘ืขื˜.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ื•ื•ืึธืก ืึทืคึผืจืึธื•ื˜ืฉื™ื– ื–ืขื ืขืŸ ื“ืึธืจื˜ ืื™ืŸ ืืจื‘ืขื˜ืŸ ืื•ื™ืฃ ืึธืคึฟืŸ ืžืงื•ืจ ื•ื•ื™ื™ื›ื•ื•ืืจื’?

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ืื™ื™ื ืขืจ ืคื•ืŸ ื“ื™ ืžืขืจืกื˜ ื‘ืึทืจื™ืžื˜ ื™ืึทื ื“ืขืงืก ืคึผืจืึทื“ื–ืฉืขืงืก ืื™ืŸ ื“ื™ ืคืขืœื“ ืคื•ืŸ ืขืคึฟืขื ืขืŸ ืžืงื•ืจ ื•ื•ื™ื™ื›ื•ื•ืืจื’ ืื™ื– ClickHouse. ื“ืึธืก ืื™ื– ืึท ื“ืึทื˜ืึทื‘ื™ื™ืก ื•ื•ืึธืก ืื™ื– ื’ืขื‘ื•ื™ืจืŸ ื•ื•ื™ ืึท ืขื ื˜ืคืขืจ ืฆื• ื“ื™ ื˜ืฉืึทืœืึทื ื“ื–ืฉื™ื– ืžื™ื˜ Yandex.Metrica.

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ืื™ืŸ Yandex.Cloud, ืžื™ืจ ื‘ืืฉืืคืŸ ClickHouse ืื•ื™ืฃ ืฉืคึผื™ืฅ ืคื•ืŸ Yandex Object Storage, ื“"ื” ืื•ื™ืฃ ืฉืคึผื™ืฅ ืคื•ืŸ ื•ื•ืึธืœืงืŸ ืกื˜ืึธืจื™ื“ื–ืฉ.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ื•ื•ื™ ืงืขืŸ ืขืก ื–ื™ื™ืŸ ื’ืขื˜ืืŸ? ื“ืึธืก ืื™ื– ืึท ื•ื•ื™ื›ื˜ื™ืง ืคื•ื ื˜ ืื™ืŸ ื“ืขื ื‘ืึทืจื™ื›ื˜.

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

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ืœื™ื ืงืก:

https://github.com/ClickHouse/ClickHouse/pull/7946 "ืคื™ืœืกื™ืกื˜ืขื ืึทื‘ืกื˜ืจืึทืงืฆื™ืข ืฉื™ื›ื˜ืข"
https://github.com/ClickHouse/ClickHouse/pull/8011 "AWS SDK S3 ื™ื ืึทื’ืจื™ื™ืฉืึทืŸ"
https://github.com/ClickHouse/ClickHouse/pull/8649 "ื‘ืึทื–ืข ื™ืžืคึผืœืึทืžืขื ื˜ื™ื™ืฉืึทืŸ ืคื•ืŸ IDisk ื™ื ื˜ืขืจืึทืคืขืงืฉืึทืŸ ืคึฟืึทืจ S3"
https://github.com/ClickHouse/ClickHouse/pull/8356 "ื™ื ืึทื’ืจื™ื™ืฉืึทืŸ ืคื•ืŸ ืœืึธื’ ืกื˜ืึธืจื™ื“ื–ืฉ ืขื ื“ื–ืฉืึทื ื– ืžื™ื˜ IDisk ืฆื•ื‘ื™ื ื“"
https://github.com/ClickHouse/ClickHouse/pull/8862 "ืœืึธื’ ืžืึธื˜ืึธืจ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ S3 ืื•ืŸ SeekableReadBuffer"
https://github.com/ClickHouse/ClickHouse/pull/9128 "ืกื˜ืึธืจื™ื“ื–ืฉ ืกื˜ืจื™ื™ืคึผ ืœืึธื’ ืก 3 ืฉื˜ื™ืฆืŸ"
https://github.com/ClickHouse/ClickHouse/pull/9415 "ืกื˜ืึธืจื™ื“ื–ืฉ MergeTree ืขืจืฉื˜ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ S3"
https://github.com/ClickHouse/ClickHouse/pull/9646 "MergeTree ืคื•ืœ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ S3"
https://github.com/ClickHouse/ClickHouse/pull/10126 "ืฉื˜ื™ืฆืŸ ReplicatedMergeTree ืื™ื‘ืขืจ S3"
https://github.com/ClickHouse/ClickHouse/pull/11134 "ืœื™ื™ื’ ืคืขืœื™ืงื™ื™ึทื˜ ืงืจืึทื“ืขื ื˜ืฉืึทืœื– ืื•ืŸ ืžื ื”ื’ ื›ืขื“ืขืจื– ืคึฟืึทืจ S3 ืกื˜ืึธืจื™ื“ื–ืฉ"
https://github.com/ClickHouse/ClickHouse/pull/10576 "S3 ืžื™ื˜ ื“ื™ื ืึทืžื™ืฉ ืคึผืจืึทืงืกื™ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ"
https://github.com/ClickHouse/ClickHouse/pull/10744 "S3 ืžื™ื˜ ืคึผืจืึทืงืกื™ ืจืขืกืึธืœื•ื•ืขืจ"

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ืœื™ื ืงืก:

https://github.com/ClickHouse/ClickHouse/pull/9760 "ื“ื™ืกืงืก 3 ื›ืึทืจื“ืœื™ื ืงืก ืึธืคึผื˜ื™ืžืึทืœ ื™ืžืคึผืœืึทืžืขื ื˜ื™ื™ืฉืึทืŸ"
https://github.com/ClickHouse/ClickHouse/pull/11522 "S3 HTTP ืงืœื™ืขื ื˜ - ื•ื™ืกืžื™ื™ื“ืŸ ืงืึทืคึผื™ื™ื ื’ ืขื ื˜ืคืขืจ ื˜ื™ื™ึทืš ืื™ืŸ ื–ื›ึผืจื•ืŸ"
https://github.com/ClickHouse/ClickHouse/pull/11561 "ื•ื™ืกืžื™ื™ื“ืŸ ืงืึทืคึผื™ื™ื ื’ ื“ื™ ื’ืื ืฆืข ืขื ื˜ืคืขืจ ื˜ื™ื™ึทืš ืื™ืŸ ื–ื›ึผืจื•ืŸ ืื™ืŸ S3 HTTP
ืงืœื™ืขื ื˜"
https://github.com/ClickHouse/ClickHouse/pull/13076 "ืคื™ื™ื™ืงื™ื™ึทื˜ ืฆื• ืงืึทืฉ ืฆื™ื™ื›ืŸ ืื•ืŸ ืื™ื ื“ืขืงืก ื˜ืขืงืขืก ืคึฟืึทืจ S3 ื“ื™ืกืง"
https://github.com/ClickHouse/ClickHouse/pull/13459 "ืžืึทืš ื˜ื™ื™ืœืŸ ืคื•ืŸ ื“ื™ืกืงืœืึธืงืึทืœ ืฆื• ื“ื™ืกืงืก 3 ืื™ืŸ ืคึผืึทืจืึทืœืขืœ"

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ืœื™ื ืงืก:

https://github.com/ClickHouse/ClickHouse/pull/12638 "ืœื™ื™ื’ ืกืขืœืขืงื˜ืขื“ ืจืึธื•ื•ืก ืื•ืŸ ืกืขืœืขืงื˜ืขื“ื‘ื™ื˜ืขืก ื’ืขืฉืขืขื ื™ืฉืŸ"
https://github.com/ClickHouse/ClickHouse/pull/12464 "ืœื™ื™ื’ ืคึผืจืึธืคื™ืœื™ื ื’ ื’ืขืฉืขืขื ื™ืฉืŸ ืคึฟื•ืŸ S3 ื‘ืขื˜ืŸ ืฆื• system.events"
https://github.com/ClickHouse/ClickHouse/pull/13028 "ืœื™ื™ื’ QueryTimeMicroseconds, SelectQueryTimeMicroseconds ืื•ืŸ InsertQueryTimeMicroseconds"

ืื•ืŸ ืขืก ืื™ื– ื’ืขื•ื•ืขืŸ ื ื™ื™ื˜ื™ืง ืฆื• ืžืึทื›ืŸ ืขืก ื“ื™ืึทื’ื ืึธืกืึทื‘ืœืข, ืฉื˜ืขืœืŸ ืึทืจื•ื™ืฃ ืžืึธื ื™ื˜ืึธืจื™ื ื’ ืื•ืŸ ืžืึทื›ืŸ ืขืก ืžืึทื ื™ื“ื–ืฉืึทื‘ืึทืœ.

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ืœืึธืžื™ืจ ื’ื™ื™ืŸ ืฆื• ื˜ืจืึทื ืกืึทืงื˜ื™ืึธื ืึทืœ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–, ืฆื• OLTP ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–, ื•ื•ืึธืก ื–ืขื ืขืŸ ื ืขืขื ื˜ืขืจ ืฆื• ืžื™ืจ ืคึผืขืจืกื ืึทืœื™.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ืื™ื™ื ืขืจ ืคื•ืŸ ื“ื™ ืคึผืจืึทื“ื–ืฉืขืงืก, ืžื™ื˜ ืึท ื‘ื™ื™ืฉืคึผื™ืœ ืคื•ืŸ ื•ื•ืึธืก ืžื™ืจ ืงืขื ืขืŸ ืจืขื“ืŸ ื•ื•ืขื’ืŸ ื•ื•ื™ ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ, ืื™ื– ื“ื™ ืงืึทื ืขืงืฉืึทืŸ ืคึผื•ืœืขืจ ืื™ืŸ Postgres.

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

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://pgconf.ru/2017/92899

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://pgconf.ru/media/2017/04/03/20170316H1_V.Borodin.pdf

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

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://www.pgcon.org/2019/schedule/events/1312.en.html

ืื™ืŸ 2019, ื‘ื™ื™ ื“ื™ PgCon ื–ื™ืฆื•ื ื’, ืื™ืš ื“ืขืจืœืื ื’ื˜ ื“ืขื ืคึผืึธืึธืœืขืจ ืฆื• ื“ื™ ื“ืขื•ื•ืขืœืึธืคึผืขืจ ืงื”ืœ. ืื™ืฆื˜ ืžื™ืจ ื”ืึธื‘ืŸ ืึท ื‘ื™ืกืœ ื•ื•ื™ื™ื ื™ืงืขืจ ื•ื•ื™ 2 ืฉื˜ืขืจืŸ ืื•ื™ืฃ GitHub, ื“"ื” ื“ื™ ืคึผืจื•ื™ืขืงื˜ ืื™ื– ืœืขื‘ืขื“ื™ืง, ื“ื™ ืคึผืจื•ื™ืขืงื˜ ืื™ื– ืคืึธืœืงืก.

ืื•ืŸ ืื•ื™ื‘ ืื™ืจ ืฉืึทืคึฟืŸ ืึท Postgres ืงื ื•ื™ืœ ืื™ืŸ Yandex.Cloud, ืขืก ื•ื•ืขื˜ ื–ื™ื™ืŸ ืึท ืงื ื•ื™ืœ ืžื™ื˜ ืึท ื’ืขื‘ื•ื™ื˜-ืื™ืŸ ืึธื“ื™ืกืกื™ื™, ื•ื•ืึธืก ืื™ื– ืจื™ืงืึทื ืคื™ื’ื™ืขืจื“ ื•ื•ืขืŸ ืกืงื™ื™ืœื™ื ื’ ื“ื™ ืงื ื•ื™ืœ ืฆื•ืจื™ืง ืึธื“ืขืจ ืฆื•ืจื™ืง.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

PgBouncer ืื ื’ืขื”ื•ื™ื‘ืŸ ืฆื• ืึทื ื˜ื•ื•ื™ืงืœืขืŸ ืคืึทืกื˜ืขืจ.

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ืขืก ื–ืขื ืขืŸ ืคื™ืœืข ื‘ืึทืงืึทืคึผืก ืื•ืŸ ื–ื™ื™ ื–ืขื ืขืŸ ืึทืœืข ืึทื ื“ืขืจืฉ. ื›ึผืžืขื˜ ื™ืขื“ืขืจ Postgres ืคืึทืจืงื•ื™ืคืขืจ ื”ืื˜ ื–ื™ื™ืŸ ืื™ื™ื’ืขื ืข ื‘ืึทืงืึทืคึผ ืœื™ื™ื–ื•ื ื’.

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://www.citusdata.com/blog/2017/08/18/introducing-wal-g-faster-restores-for-postgres/

ื‘ืฉืขืช ืžื™ืจ ืืจื‘ืขื˜ืŸ ืื•ื™ืฃ ื“ืขื ืึทืจื•ื™ืกื’ืขื‘ืŸ, CitusData ืœืึธื ื˜ืฉื˜ ื“ื™ WAL-G ืคึผืจื•ื™ืขืงื˜. ื“ืึธืก ืื™ื– ืึท ื‘ืึทืงืึทืคึผ ืกื™ืกื˜ืขื ื•ื•ืึธืก ืื™ื– ื’ืขืžืื›ื˜ ืžื™ื˜ ืึทืŸ ืื•ื™ื’ ืฆื• ื“ื™ ื•ื•ืึธืœืงืŸ ืกื•ื•ื™ื•ื•ืข. ืื™ืฆื˜ CitusData ืื™ื– ืฉื•ื™ืŸ ื˜ื™ื™ืœ ืคื•ืŸ ืžื™ื™ืงืจืึธืกืึธืคึฟื˜. ืื•ืŸ ืื™ืŸ ื“ืขื ืžืึธืžืขื ื˜, ืžื™ืจ ื˜ืึทืงืข ืœื™ื™ืงื˜ ื“ื™ ื’ืขื“ืื ืงืขืŸ ื•ื•ืึธืก ื–ืขื ืขืŸ ื’ืขื•ื•ืขืŸ ื’ืขืœื™ื™ื’ื˜ ืื™ืŸ ื“ื™ ืขืจืฉื˜ ืจื™ืœื™ืกื™ื– ืคื•ืŸ WAL-G. ืื•ืŸ ืžื™ืจ ืื ื’ืขื”ื•ื™ื‘ืŸ ืงืึทื ื˜ืจื™ื‘ื™ื•ื˜ื™ื ื’ ืฆื• ื“ืขื ืคึผืจื•ื™ืขืงื˜.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://github.com/wal-g/wal-g/graphs/contributors

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

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

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

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

ืื•ืŸ ืžื™ืจ ืคึผืจืึธืžืึธื˜ืขื“ ื“ืขื ืคึผืฉื•ื˜ ื’ืขื“ืึทื ืง. ืื•ืŸ, ืขืก ืžื™ื™ื ื˜ ืฆื• ืื•ื ื“ื–, ืžื™ืจ ื’ืขืจืื˜ืŸ ืฆื• ื™ื ืกื˜ืจื•ืžืขื ื˜ ืขืก.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ืึธื‘ืขืจ ื“ืึธ ืขืก ืžื•ื–ืŸ ื–ื™ื™ืŸ ื’ืขื–ืึธื’ื˜ ืึทื– Yandex.Cloud ื”ืื˜ ืึทืŸ ื™ื ืขืจืœืขืš ื™ื ืกื˜ืึทืœื™ืจื•ื ื’ ืคื•ืŸ ื’ืขืจืื˜ืŸ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืื•ืŸ ืขืก ืกื˜ืึทืจื˜ืขื“ ืึท ืœืึทื ื’ ืฆื™ื™ึทื˜ ืฆื•ืจื™ืง ืื™ืŸ Yandex.Mail. ื“ื™ ืขืงืกืคึผืขืจื˜ื™ื– ื•ื•ืึธืก ื”ืื˜ ืื™ืฆื˜ ื’ืขืคึฟื™ืจื˜ ืฆื• ื’ืขืจืื˜ืŸ Postgres ืื™ื– ื’ืขื•ื•ืขืŸ ืึทืงื™ื•ืžื™ืึทืœื™ื™ื˜ื™ื“ ื•ื•ืขืŸ ื“ื™ ืคึผืึธืกื˜ ื’ืขื•ื•ืืœื˜ ืฆื• ืึทืจื™ื‘ืขืจืคื™ืจืŸ ืื™ืŸ Postgres.

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

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

ืื™ืฆื˜ ื“ื™ ื™ื ืขืจืœืขืš ื™ื ืกื˜ืึทืœื™ืจื•ื ื’ ืคื•ืŸ Postgres ืื™ื– ืขื˜ืœืขื›ืข ืคึผืขื˜ืึทื‘ื™ื˜ืขืก ืคื•ืŸ ื“ืึทื˜ืŸ. ื“ืึธืก ื–ืขื ืขืŸ ืขื˜ืœืขื›ืข ืžื™ืœื™ืึทื ื– ืคื•ืŸ ืจื™ืงื•ื•ืขืก ืคึผืขืจ ืกืขืงื•ื ื“ืข. ื“ืืก ื–ืขื ืขืŸ ื˜ื•ื™ื–ื ื˜ืขืจ ืคื•ืŸ ืงืœืึทืกื˜ืขืจื–. ืขืก ืื™ื– ื–ื™ื™ืขืจ ื’ืจื•ื™ืก.

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

ืึทืŸ ื™ื ื•ื•ื™ื™ืจืึทื ืžืขื ืึทืœ ืื™ื– ืึท ืžื™ืŸ ืคื•ืŸ ืฉื™ื™ื›ื•ืช ื•ื•ืึธืก ืžื™ืจ ื“ืขืจื•ื•ืึทืจื˜ืŸ ืฆื• ืฉื˜ืขื ื“ื™ืง ื”ืึทืœื˜ืŸ.

ื ื–ื™ื™ืขืจ ืงืจื™ื˜ื™ืฉ ืกื™ื˜ื•ืึทืฆื™ืข ืคึฟืึทืจ ืื•ื ื“ื–. ืขืก ื™ื ื“ื™ืงื™ื™ืฅ ืึทื– ืขื˜ืœืขื›ืข ื“ืึทื˜ืŸ ืงืขืŸ ื–ื™ื™ืŸ ืคืึทืจืคืึทืœืŸ. ืื•ืŸ ื“ืึทื˜ืŸ ืึธื ื•ื•ืขืจ ืื™ื– ืขืคึผืขืก ื“ืึทื•ื ืจื™ื™ื˜ ืงืึทื˜ืึทืกื˜ืจืึธืคื™ืง.

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

ืื•ืŸ ื“ืึธ ืงื•ืžื˜ ืึท ืกื™ื˜ื•ืึทืฆื™ืข ื•ื•ืึธืก ืกืึทื’ื“ื–ืฉืขืกืฅ ืึทื– ืขืก ืงืขืŸ ื–ื™ื™ืŸ ืึท ืกื™ื˜ื•ืึทืฆื™ืข ื•ื•ืึธืก ืžื™ืจ ืงืขืŸ ื ื™ืฉื˜ ื–ื™ื™ืŸ ืฆื•ื’ืขื’ืจื™ื™ื˜. ืื• ืŸ ืžื™ ืจ ื”ืื‘ ืŸ ื–ื™ ืš ืื ื’ืขื”ื•ื™ื‘ ืŸ ืฆื•ื’ืจืฒื˜ ืŸ ืฆ ื• ื“ืข ืจ ืœืื’ืข .

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://commitfest.postgresql.org/23/2171/

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

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

ืึธื‘ืขืจ! ืกืงืึทื ื™ื ื’ ืœืึธื’ืก ืื™ื– ืึท ื‘ื™ืœื™ืง ืึธืคึผืขืจืึทืฆื™ืข ืื•ื™ืฃ ืื™ื™ืŸ ืงื ื•ื™ืœ ืื•ืŸ ืงืึทื˜ืึทืกื˜ืจืึธืคื™ืงืึทืœืœื™ ื˜ื™ื™ึทืขืจ ืคึฟืึทืจ ืึท ื˜ื•ื™ื–ื ื˜ ืงืœืึทืกื˜ืขืจื–.

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

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://www.postgresql.org/message-id/flat/[ืื™ืžืขื™ืœ ื‘ืืฉื™ืฆื˜]

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

ืื•ืŸ ืžื™ืจ ื’ืขืคื•ื ืขืŸ ืึทื– ืื•ื™ื‘ ืื™ืจ ืึทืจื‘ืขื˜ืŸ ืขืก ืื™ืŸ ืึท ื•ื•ืึธื’, ืขืก ื–ืขื ืขืŸ ื‘ืึทื’ื–. ืžื™ ืจ ื”ืื‘ ืŸ ื– ืฒ ืื ื’ืขื”ื•ื™ื‘ ืŸ ืคืืจืจื™ื›ื˜ืŸ . ืื•ื ื“ื–ืขืจ ืงืขืจืขืงืฉืึทื ื– ื–ืขื ืขืŸ ืื ื’ืขื ื•ืžืขืŸ.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://www.postgresql.org/message-id/flat/[ืื™ืžืขื™ืœ ื‘ืืฉื™ืฆื˜]

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://commitfest.postgresql.org/29/2667/

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

ืžื™ืจ ื’ืขืฉืจื™ื‘ืŸ ืงืึธื“ ื•ื•ืึธืก ื–ืึธืœ ื ืึธื›ื’ื™ื™ืŸ ืึทืœืข ืงืขื ืขืŸ ... ืคึผืจืึธื˜ืึธืงืึธืœืก. ืžื™ืจ ื“ื™ืกืงืึทืกื˜ ื“ืขื ืœืึทื˜ืข ืคึฟืึทืจ ื’ืึทื ืฅ ืขื˜ืœืขื›ืข ืžืึธืœ ืžื™ื˜ Peter Gaghan ืคึฟื•ืŸ Crunchy Data. ืขืจ ื”ืื˜ ืฆื• ืึท ื‘ื™ืกืœ ืžืึธื“ื™ืคื™ืฆื™ืจืŸ ื“ื™ ื™ื’ื–ื™ืกื˜ื™ื ื’ ื‘-ื‘ื•ื™ื ืื™ืŸ ืคึผืึธืกื˜ื’ืจืขืก ืฆื• ืึธื ื ืขืžืขืŸ ื“ืขื ืœืึทื˜ืข. ืžืณื”ืื˜ ืื™ื ืื ื’ืขื ื•ืžืขืŸ. ืื•ืŸ ืื™ืฆื˜ ืงืึธื ื˜ืจืึธืœื™ืจื•ื ื’ ื™ื ื“ืขืงืกื™ื– ืื•ื™ืฃ ืจืขืคึผืœืึทืงืึทื– ืื™ื– ืื•ื™ืš ื’ืขื•ื•ืืจืŸ ืขืคืขืงื˜ื™ื•ื• ื’ืขื ื•ื’ ืฆื• ื“ืขื˜ืขืงื˜ ื“ื™ ื•ื•ื™ื™ืึทืœื™ื™ืฉืึทื ื– ื•ื•ืึธืก ืžื™ืจ ื”ืึธื‘ืŸ ื’ืขืคึผืœืึธื ื˜ืขืจื˜. ื“ืึธืก ืื™ื–, ื“ืึธืก ื–ืขื ืขืŸ ื“ื™ ื•ื•ื™ื™ืึทืœื™ื™ืฉืึทื ื– ื•ื•ืึธืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ื’ืขืคึฟื™ืจื˜ ื“ื•ืจืš ืขืจืจืึธืจืก ืื™ืŸ ื“ื™ืกืง Firmware, ื‘ืึทื’ื– ืื™ืŸ Postgres, ื‘ืึทื’ื– ืื™ืŸ ื“ื™ ืœื™ื ื•ืงืก ืงืขืจืŸ ืื•ืŸ ื™ื™ึทื–ื ื•ื•ืึทืจื’ ืคึผืจืึธื‘ืœืขืžืก. ื’ืึทื ืฅ ืึท ื‘ืจื™ื™ื˜ ืจืฉื™ืžื” ืคื•ืŸ ืงื•ื•ืืœืŸ ืคื•ืŸ ืคืจืื‘ืœืขืžืขืŸ ืคึฟืึทืจ ื•ื•ืึธืก ืžื™ืจ ื–ืขื ืขืŸ ืคึผืจื™ืคึผืขืจื™ื ื’.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://www.postgresql.org/message-id/flat/38AF687F-8F6B-48B4-AB9E-A60CFD6CC261%40enterprisedb.com#0e86a12c01d967bac04a9bf83cd337cb

ืื‘ืขืจ ื—ื•ืฅ ื™ื ื“ืขืงืกื™ื–, ืขืก ืื™ื– ืึทื–ืึท ืึท ื˜ื™ื™ืœ ื•ื•ื™ ืงื•ืคึผืข, ื“"ื” ื“ืขืจ ืึธืจื˜ ื•ื•ื• ื“ื™ ื“ืึทื˜ืŸ ื–ืขื ืขืŸ ืกื˜ืึธืจื“. ืื•ืŸ ืขืก ื–ืขื ืขืŸ ื ื™ืฉื˜ ืคื™ืœืข ื™ื ื•ื•ื™ื™ืจืึทื ืžืึทื ืฅ ื•ื•ืึธืก ืงืขืŸ ื–ื™ื™ืŸ ืึธืคึผื’ืขืฉื˜ืขืœื˜.

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

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://www.postgresql.org/message-id/flat/fe9b3722df94f7bdb08768f50ee8fe59%40postgrespro.ru

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

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

ืื™ืš ื’ืขืคึฟื•ื ืขืŸ ืึท ื“ื™ืกืงื•ืกื™ืข ื•ื•ืขื’ืŸ ื“ืขื ืฉื˜ืจื™ืš. ืื•ืŸ ืขืจ ื”ืื˜ ื’ืขืฉืจื™ื‘ืŸ ืื– ืžื™ืจ ื”ืื‘ืŸ ื’ืขื˜ืจืืคืขืŸ ื“ืขื ืฉื˜ืจื™ืš ืื•ืŸ ืก'ืื™ื– ื’ืขื•ื•ืขืŸ ืื•ืžื‘ืืงื•ื•ืขื, ื ืžืขื ื˜ืฉ ื”ืื˜ ื–ื™ืš ืื•ื™ืคื’ืขื›ืืคื˜ ื‘ื™ื™ื ืื›ื˜, ื›ื“ื™ ืฆื• ืคืืจืฉื˜ื™ื™ืŸ ื•ื•ืืก ื“ืืก ืื™ื–.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://www.postgresql.org/message-id/flat/fe9b3722df94f7bdb08768f50ee8fe59%40postgrespro.ru

ื“ื™ ืงื”ื™ืœื” ื”ืึธื˜ ื’ืขืขื ื˜ืคืขืจื˜, "ืึธ, ืžื™ืจ ื˜ืึทืงืข ื“ืึทืจืคึฟืŸ ืฆื• ืคืึทืจืจื™ื›ื˜ืŸ ืขืก."

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://greenplum.org/greenplum-database-tables-compression/

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

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

ื“ื™ ื‘ื—ื•ืจื™ื ืคื•ืŸ ื“ืขืจ ื˜ืึทืงืกื™ ื–ืขื ืขืŸ ื’ืขืงื•ืžืขืŸ ืฆื• ืžื™ืจ ืื•ืŸ ื’ืขื–ืึธื’ื˜: โ€œืึทื ื“ืจื™ื™, ืื™ืจ ืงืขื ื˜ ืคึผืึธืกื˜ื’ืจืขืก. ืื•ืŸ ื“ืึธ ืขืก ืื™ื– ื›ึผืžืขื˜ ื“ื™ ื–ืขืœื‘ืข. ื‘ืึทืฉื˜ื™ืžืขืŸ ืฆื• 20 ืžื™ื ื•ื˜. ืื™ืจ ื ืขืžืขืŸ ืขืก ืื•ืŸ ื˜ืึธืŸ ืขืก. โ€ ืื™ืš ื’ืขื“ืึทื ืง ืึทื– ื™ืึธ, ืื™ืš ื•ื•ื™ืกืŸ Postgres, ืกื•ื•ื™ื˜ืฉื™ื ื’ ืคึฟืึทืจ 20 ืžื™ื ื•ื˜ - ืื™ืš ื“ืึทืจืคึฟืŸ ืฆื• ื˜ืึธืŸ ื“ืึธืก.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://github.com/greenplum-db/gpdb/commit/179feb77a034c2547021d675082aae0911be40f7

ืื‘ืขืจ ื ื™ื™ืŸ, ืขืก ืื™ื– ื ื™ืฉื˜ ื’ืขื•ื•ืขืŸ 20 ืžื™ื ื•ื˜, ืื™ืš ื’ืขืฉืจื™ื‘ืŸ ืขืก ืื™ื‘ืขืจ ื—ื“ืฉื™ื. ืื•ื™ืฃ ื“ืขืจ PgConf.Russia ื–ื™ืฆื•ื ื’, ืื™ืš ืึทืคึผืจืึธื•ื˜ืฉื˜ Heikki Linakangas ืคึฟื•ืŸ Pivotal ืื•ืŸ ื’ืขืคืจืขื’ื˜: "ื–ืขื ืขืŸ ืขืก ืงื™ื™ืŸ ืคืจืื‘ืœืขืžืขืŸ ืžื™ื˜ ื“ืขื? ืคืืจื•ื•ืืก ืื™ื– ืขืก ืงื™ื™ืŸ ืึทืคึผืขื ื“ ืึธืคึผื˜ื™ืžื™ื–ืขื“ ื˜ื™ืฉ ืงืœืึทืกื˜ืขืจื™ื ื’? ืขืจ ื–ืื’ื˜: "ืื™ืจ ื ืขืžืขืŸ ื“ื™ ื“ืึทื˜ืŸ. ืื™ืจ ืกืึธืจื˜, ืื™ืจ ืจื™ืขืจื™ื™ื ื“ื–ืฉ. ืขืก ืื™ื– ื ืึธืจ ืึท ืึทืจื‘ืขื˜." ืื™ืš: "ืึธื”, ื™ืึธ, ืื™ืจ ื ืึธืจ ื“ืึทืจืคึฟืŸ ืฆื• ื ืขืžืขืŸ ืขืก ืื•ืŸ ื˜ืึธืŸ ืขืก." ืขืจ ื–ืื’ื˜: "ื™ื, ืžื™ืจ ื“ืึทืจืคึฟืŸ ืคืจื™ื™ ื”ืขื ื˜ ืฆื• ื˜ืึธืŸ ื“ืึธืก." ืื™ืš ื”ืื‘ ื’ืขืžื™ื™ื ื˜ ืื– ืื™ืš ื“ืืจืฃ ื“ืืก ืื•ื•ื“ืื™ ื˜ืืŸ.

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://github.com/greenplum-db/gpdb/issues/10150

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

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://github.com/greenplum-db/gpdb/pull/10290

ืื™ืš ืคืึทืจืคืขืกื˜ื™ืงื˜ ื“ืขื ื–ืฉื•ืง. ื’ืขืฉื™ืงื˜ ืึท ืฆื™ืขืŸ ื‘ืงืฉื” ืฆื• ื“ื™ ืคื™ืงืกืขืจื–. ืžืณื”ืื˜ ืื™ื ื“ืขืจื”ืจื’ืขื˜.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://github.com/greenplum-db/gpdb-postgres-merge/pull/53

ื ืึธืš ื•ื•ืึธืก ืขืก ื”ืึธื˜ ื–ื™ืš ืื•ื™ืกื’ืขื“ืจื™ื™ื˜ ืึทื– ื“ื™ ืคืึทื ื’ืงืฉืึทื ืึทืœื™ื˜ื™ ื“ืึทืจืฃ ื–ื™ื™ืŸ ื‘ืืงื•ืžืขืŸ ืื™ืŸ ื“ื™ Greenplum ื•ื•ืขืจืกื™ืข ืคึฟืึทืจ PostgreSQL 12. ื“ืึธืก ืื™ื–, ื“ื™ 20-ืžื™ื ื•ื˜ ืคึผืึทืกื™ืจื•ื ื’ ื”ืืœื˜ ืžื™ื˜ ื ื™ื™ึทืข ื˜ืฉื™ืงืึทื•ื•ืข ืึทื“ื•ื•ืขื ื˜ืฉืขืจื–. ืขืก ืื™ื– ื’ืขื•ื•ืขืŸ ื˜ืฉื™ืงืึทื•ื•ืข ืฆื• ืึธื ืจื™ืจืŸ ื“ื™ ืงืจืึทื ื˜ ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’, ื•ื•ื• ื“ื™ ืงื”ืœ ืื™ื– ืงืึทื˜ื™ื ื’ ื ื™ื™ึทืข ืื•ืŸ ืžืขืจืกื˜ ื•ื•ื™ื›ื˜ื™ืง ืคึฟืขื™ึดืงื™ื™ื˜ืŸ. ืขืก ืื™ื– ืคืึทืจืคืจื•ื™ืจืŸ.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

https://github.com/greenplum-db/gpdb/pull/10565

ืื‘ืขืจ ืขืก ื”ืื˜ ื ื™ืฉื˜ ืกื•ืฃ ื“ืึธืจื˜. ื ืืš ืืœืขืก ื”ืื˜ ื–ื™ืš ืืจื•ื™ืกื’ืขืฉื˜ืขืœื˜ ืื– ืžื™ืจ ื“ืืจืคืŸ ืฉืจื™ื™ื‘ืŸ ื“ืืงื•ืžืขื ื˜ืืฆื™ืข ืคืืจ ื“ืขื ืืœืขื.

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

ืื•ืŸ ื“ืึธ, ื•ื•ืึธืœื˜ ื•ื•ื™, ื”ืึธื˜ ื–ื™ืš ื“ื™ ืคึผืึทืกื™ืจื•ื ื’ ื’ืขืขื ื“ื™ืงื˜. ืื•ืŸ ื“ื• ื•ื•ื™ื™ืกื˜ ื•ื•ืืก ื“ืขืžืืœื˜ ืื™ื– ื’ืขืฉืขืŸ? ื“ื™ ื’ื™ื™ื– ืคึฟื•ืŸ ื“ืขืจ ื˜ืึทืงืกื™ ื’ืขืงื•ืžืขืŸ ืฆื• ืžื™ืจ ืื•ืŸ ื’ืขื–ืื’ื˜: "ืขืก ื–ืขื ืขืŸ ื ืึธืš ืฆื•ื•ื™ื™ ืึทื“ื•ื•ืขื ื˜ืฉืขืจื–, ื™ืขื“ืขืจ ืคึฟืึทืจ 10 ืžื™ื ื•ื˜." ืื•ืŸ ื•ื•ืึธืก ื–ืึธืœ ืื™ืš ื–ืึธื’ืŸ ื–ื™ื™? ืื™ืš ื’ืขื–ืื’ื˜ ืึทื– ืื™ืฆื˜ ืื™ืš ื•ื•ืขื˜ ื’ืขื‘ืŸ ืึท ื‘ืึทืจื™ื›ื˜ ืื•ื™ืฃ ื•ื•ืึธื’, ื“ืขืžืึธืœื˜ ืžื™ืจ ื•ื•ืขืœืŸ ื–ืขืŸ ื“ื™ื™ืŸ ืึทื“ื•ื•ืขื ื˜ืฉืขืจื–, ื•ื•ื™ื™ึทืœ ื“ืึธืก ืื™ื– ืึท ื˜ืฉื™ืงืึทื•ื•ืข ืึทืจื‘ืขื˜.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

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

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

ืึทื– ืก ืึทืœืข. ืœืืžื™ืจ ื’ื™ื™ืŸ ื•ื•ื™ื™ื˜ืขืจ ืฆื• ื“ื™ ืคืจืื’ืขืก.

ื•ื•ืึธืก ืื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื˜ืึธืŸ ืื™ืŸ ืขืคึฟืŸ ืžืงื•ืจ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ (Yandex.Cloud)

ืคึฟืจืื’ืŸ ืกืขืกื™ืข

ื”ืขืœื! ืžื™ืจ ื”ืึธื‘ืŸ ืืŸ ืื ื“ืขืจ ืงืฉื™ื ืื•ืŸ ืขื ื˜ืคึฟืขืจืŸ ืกืขืกื™ืข. ืื•ืŸ ืื™ืŸ ื“ื™ ืกื˜ื•ื“ื™ืข ืึทื ื“ืจื™ื™ ื‘ืึธืจืึธื“ื™ืŸ. ื“ืึธืก ืื™ื– ื“ืขืจ ืžืขื ื˜ืฉ ื•ื•ืึธืก ื”ืึธื˜ ืื™ืจ ื ืึธืจ ื’ืขื–ืึธื’ื˜ ื•ื•ืขื’ืŸ ื“ืขื ืฆื•ืฉื˜ื™ื™ึทืขืจ ืคื•ืŸ Yandex.Cloud ืื•ืŸ Yandex ืฆื• ืขืคึฟืขื ืขืŸ ืžืงื•ืจ. ืื•ื ื“ื–ืขืจ ื‘ืึทืจื™ื›ื˜ ืื™ืฆื˜ ืื™ื– ื ื™ืฉื˜ ืœืขื’ืึทืžืจืข ื•ื•ืขื’ืŸ ื“ื™ ืงืœืึธื•ื“, ืึธื‘ืขืจ ืื™ืŸ ื“ืขืจ ื–ืขืœื‘ื™ืงืขืจ ืฆื™ื™ื˜ ืžื™ืจ ื–ืขื ืขืŸ ื‘ืื–ื™ืจื˜ ืื•ื™ืฃ ืึทื–ืึท ื˜ืขืงื ืึทืœืึทื“ื–ืฉื™ื–. ืึธืŸ ื•ื•ืึธืก ืื™ืจ ื”ืึธื˜ ื’ืขื˜ืืŸ ืื™ืŸ ื™ืึทื ื“ืขืงืก, ืขืก ื•ื•ืึธืœื˜ ื–ื™ื™ืŸ ืงื™ื™ืŸ ื“ื™ื ืกื˜ ืื™ืŸ Yandex.Cloud, ืึทื–ื•ื™ ื“ืึทื ืงืขืŸ ื“ื™ืจ ืคึผืขืจืกื ืึทืœื™. ืื•ืŸ ื“ืขืจ ืขืจืฉื˜ืขืจ ืงืฉื™ื ืคื•ืŸ ื“ื™ ื‘ืจืึธื“ืงืึทืกื˜: "ื•ื•ืึธืก ืื™ื– ื’ืขืฉืจื™ื‘ืŸ ืื•ื™ืฃ ื™ืขื“ืขืจ ืคื•ืŸ ื“ื™ ืคึผืจืึทื“ื–ืฉืขืงืก ื•ื•ืึธืก ืื™ืจ ื”ืึธื˜ ื“ืขืจืžืื ื˜?"

ื“ื™ ื‘ืึทืงืึทืคึผ ืกื™ืกื˜ืขื ืื™ืŸ WAL-G ืื™ื– ื’ืขืฉืจื™ื‘ืŸ ืื™ืŸ Go. ื“ืึธืก ืื™ื– ืื™ื™ื ืขืจ ืคื•ืŸ ื“ื™ ื ื™ื™ึทืข ืคึผืจืึทื“ื–ืฉืขืงืก ื•ื•ืึธืก ืžื™ืจ ื”ืึธื‘ืŸ ื’ืขืืจื‘ืขื˜ ืื•ื™ืฃ. ืขืจ ืื™ื– ืžืžืฉ ื‘ืœื•ื™ื– 3 ื™ืืจ ืึทืœื˜. ืื•ืŸ ืึท ื“ืึทื˜ืึทื‘ื™ื™ืก ืื™ื– ืึธืคื˜ ื•ื•ืขื’ืŸ ืจื™ืœื™ื™ืึทื‘ื™ืœืึทื˜ื™. ืื•ืŸ ื“ืึธืก ืžื™ื™ื ื˜ ืึทื– ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ื–ืขื ืขืŸ ื’ืึทื ืฅ ืึทืœื˜ ืื•ืŸ ื–ื™ื™ ื–ืขื ืขืŸ ื™ื•ื–ืฉืึทื•ื•ืึทืœื™ ื’ืขืฉืจื™ื‘ืŸ ืื™ืŸ ืกื™ ื“ื™ ืคึผืึธืกื˜ื’ืจืขืก ืคึผืจื•ื™ืขืงื˜ ืื ื’ืขื”ื•ื™ื‘ืŸ ืžื™ื˜ ื•ื•ืขื’ืŸ 30 ื™ืืจ ืฆื•ืจื™ืง. ื“ืขืจื ืึธืš ื“ื™ C89 ืื™ื– ื’ืขื•ื•ืขืŸ ื“ื™ ืจืขื›ื˜ ื‘ืจื™ืจื”. ืื•ืŸ ืคึผืึธืกื˜ื’ืจืขืก ืื™ื– ื’ืขืฉืจื™ื‘ืŸ ืื•ื™ืฃ ืื™ื. ืžืขืจ ืžืึธื“ืขืจืŸ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ืึทื–ืึท ื•ื•ื™ ืงืœื™ืงืงื›ืึทื•ืก ื–ืขื ืขืŸ ื™ื•ื–ืฉืึทื•ื•ืึทืœื™ ื’ืขืฉืจื™ื‘ืŸ ืื™ืŸ C ++. ืึทืœืข ืกื™ืกื˜ืขื ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืื™ื– ื‘ืื–ื™ืจื˜ ืื•ื™ืฃ C ืื•ืŸ C ++.

ื ืงืฉื™ื ืคื•ืŸ ืื•ื ื“ื–ืขืจ ืคื™ื ืึทื ืฆื™ืขืœ ืคืึทืจื•ื•ืึทืœื˜ืขืจ, ื•ื•ืึธืก ืื™ื– ืคืึทืจืึทื ื˜ื•ื•ืึธืจื˜ืœืขืš ืคึฟืึทืจ ื”ื•ืฆืื•ืช ืื™ืŸ ืงืœืึธื•ื“: "ืคืืจื•ื•ืืก ื˜ื•ื˜ ืงืœืึธื•ื“ ืคืึทืจื‘ืจืขื ื’ืขืŸ ื’ืขืœื˜ ืื•ื™ืฃ ืฉื˜ื™ืฆืŸ ืึธืคึฟืŸ ืžืงื•ืจ?"

ืขืก ืื™ื– ืึท ืคึผืฉื•ื˜ ืขื ื˜ืคืขืจ ืคึฟืึทืจ ื“ื™ ืคื™ื ืึทื ืฆื™ืขืœ ืคืึทืจื•ื•ืึทืœื˜ืขืจ ื“ืึธ. ืžื™ืจ ื˜ืึธืŸ ื“ืึธืก ืฆื• ืžืึทื›ืŸ ืื•ื ื“ื–ืขืจ ื‘ืึทื“ื™ื ื•ื ื’ืก ื‘ืขืกืขืจ. ืื™ืŸ ื•ื•ืึธืก ื•ื•ืขื’ืŸ ืงืขื ืขืŸ ืžื™ืจ ื˜ืึธืŸ ื‘ืขืกืขืจ? ืžื™ืจ ืงืขื ืขืŸ ื˜ืึธืŸ ื˜ื™ื ื’ื– ืžืขืจ ื™ืคื™ืฉืึทื ื˜ืœื™, ืคืึทืกื˜ืขืจ ืื•ืŸ ืžืึทื›ืŸ ื“ื™ ื˜ื™ื ื’ื– ืžืขืจ ืกืงืึทืœืึทื‘ืœืข. ืึธื‘ืขืจ ืคึฟืึทืจ ืื•ื ื“ื–, ื“ื™ ื’ืขืฉื™ื›ื˜ืข ืื™ื– ื‘ืคึฟืจื˜ ื•ื•ืขื’ืŸ ืจื™ืœื™ื™ืึทื‘ื™ืœืึทื˜ื™. ืคึฟืึทืจ ื‘ื™ื™ึทืฉืคึผื™ืœ, ืื™ืŸ ืึท ื‘ืึทืงืึทืคึผ ืกื™ืกื˜ืขื ืžื™ืจ ืึธืคึผืฉืึทืฆืŸ 100% ืคื•ืŸ ื“ื™ ืคึผืึทื˜ืฉืึทื– ื•ื•ืึธืก ืึทืคึผืœื™ื™ื– ืฆื• ืขืก. ืžื™ืจ ื•ื•ื™ืกืŸ ื•ื•ืึธืก ื“ื™ ืงืึธื“ ืื™ื–. ืื•ืŸ ืžื™ืจ ื–ืขื ืขืŸ ืžืขืจ ื‘ืึทืงื•ื•ืขื ืจืึธื•ืœื™ื ื’ ื ื™ื™ึท ื•ื•ืขืจืกื™ืขืก ืฆื• ืคึผืจืึธื“ื•ืงืฆื™ืข. ืึทื– ืื™ื–, ืขืจืฉื˜ืขืจ ืคื•ืŸ ืึทืœืข, ืขืก ืื™ื– ื•ื•ืขื’ืŸ ื‘ื˜ื—ื•ืŸ, ื•ื•ืขื’ืŸ ื’ืจื™ื™ื˜ืงื™ื™ึทื˜ ืคึฟืึทืจ ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืื•ืŸ ืจื™ืœื™ื™ืึทื‘ื™ืœืึทื˜ื™

ืืŸ ืื ื“ืขืจ ืงืฉื™ื: "ื–ืขื ืขืŸ ื“ื™ ื‘ืื“ืขืจืคืขื ื™ืฉืŸ ืคื•ืŸ ืคื•ื ื“ืจื•ื™ืกื ื“ื™ืง ื™ื•ื–ืขืจื– ื•ื•ืึธืก ืœืขื‘ืŸ ืื™ืŸ Yandex.Cloud ืึทื ื“ืขืจืฉ ืคื•ืŸ ื™ื ืขืจืœืขืš ื™ื•ื–ืขืจื– ื•ื•ืึธืก ืœืขื‘ืŸ ืื™ืŸ ื“ื™ ื™ื ืขืจืœืขืš ืงืœืึธื•ื“?"

ื“ื™ ืžืึทืกืข ืคึผืจืึธืคื™ืœ ืื™ื–, ืคื•ืŸ ืงื•ืจืก, ืึทื ื“ืขืจืฉ. ืื‘ืขืจ ืคื•ืŸ ื“ื™ ืคื•ื ื˜ ืคื•ืŸ ืžื™ื™ื ื•ื ื’ ืคื•ืŸ ืžื™ื™ืŸ ืึธืคึผื˜ื™ื™ืœื•ื ื’, ืึทืœืข ื“ื™ ืกืคึผืขืฆื™ืขืœ ืื•ืŸ ื˜ืฉื™ืงืึทื•ื•ืข ืงืึทืกืขืก ื–ืขื ืขืŸ ื‘ืืฉืืคืŸ ืื•ื™ืฃ ืึท ื ื™ื˜-ื ืึธืจืžืึทืœ ืžืึทืกืข. ื“ืขื•ื•ืขืœืึธืคึผืขืจืก ืžื™ื˜ ืคืึทื ื˜ืึทื–ื™ืข, ื“ืขื•ื•ืขืœืึธืคึผืขืจืก ื•ื•ืึธืก ื˜ืึธืŸ ื“ื™ ืื•ืžื’ืขืจื™ื›ื˜, ื–ืขื ืขืŸ ื•ื•ื™ ืžืกืชึผืžื ืฆื• ื–ื™ื™ืŸ ื’ืขืคึฟื•ื ืขืŸ ื™ื ืขืจืœืขืš ืื•ืŸ ื•ื™ืกื•ื•ื™ื™ื ื™ืง. ืื™ืŸ ื“ืขื ืึทื›ื˜ื•ื ื’, ืžื™ืจ ื–ืขื ืขืŸ ืึทืœืข ื‘ืขืขืจืขืš ื“ืขืจ ื–ืขืœื‘ื™ืงืขืจ. ืื•ืŸ, ืžื™ืกื˜ืึธืžืข, ื“ืขืจ ื‘ืœื•ื™ื– ื•ื•ื™ื›ื˜ื™ืง ืฉื˜ืจื™ืš ืื™ืŸ ื“ื™ ื™ืึทื ื“ืขืงืก ืึธืคึผืขืจืึทืฆื™ืข ืคื•ืŸ โ€‹โ€‹ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ืื™ื– ืึทื– ืื™ืŸ ื™ืึทื ื“ืขืงืก ืžื™ืจ ื”ืึธื‘ืŸ ืึท ืœืขืจื ืขืŸ. ืื™ืŸ ืขื˜ืœืขื›ืข ืคื•ื ื˜, ืขื˜ืœืขื›ืข ืึทื•ื•ื™ื™ืœืึทื‘ื™ืœื™ื˜ื™ ื–ืึธื ืข ื’ืึธืจ ื’ื™ื™ื˜ ืื™ืŸ ืฉืึธื˜ืŸ, ืื•ืŸ ืึทืœืข ื™ืึทื ื“ืขืงืก ื‘ืึทื“ื™ื ื•ื ื’ืก ืžื•ื–ืŸ ืขืคืขืก ืคืึธืจื–ืขืฆืŸ ืฆื• ืคื•ื ืงืฆื™ืึธื ื™ืจืŸ ื˜ืจืึธืฅ ื“ืขื. ื“ืึธืก ืื™ื– ืึท ืงืœื™ื™ืŸ ื—ื™ืœื•ืง. ืึธื‘ืขืจ ืขืก ืงืจื™ื™ื™ืฅ ืึท ืคึผืœืึทืฅ ืคื•ืŸ ืคืึธืจืฉื•ื ื’ ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืื™ืŸ ื“ื™ ืฆื•ื‘ื™ื ื“ ืคื•ืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืื•ืŸ ื ืขืฅ ืึธื ืœื™ื™ื’ืŸ. ืึทื ื“ืขืจืฉ, ืคื•ื ื“ืจื•ื™ืกื ื“ื™ืง ืื•ืŸ ื™ื ืขืจืœืขืš ื™ื ืกื˜ืึทืœื™ื™ืฉืึทื ื– ื“ื–ืฉืขื ืขืจื™ื™ื˜ ื“ื™ ื–ืขืœื‘ืข ืจื™ืงื•ื•ืขืก ืคึฟืึทืจ ืคึฟืขื™ึดืงื™ื™ื˜ืŸ ืื•ืŸ ืขื ืœืขืš ืจื™ืงื•ื•ืขืก ืคึฟืึทืจ ื™ืžืคึผืจื•ื•ื•ื™ื ื’ ืจื™ืœื™ื™ืึทื‘ื™ืœืึทื˜ื™ ืื•ืŸ ืคืึธืจืฉื˜ืขืœื•ื ื’.

ื•ื•ื™ื™ึทื˜ืขืจ ืงืฉื™ื: "ื•ื•ื™ ื˜ืึธืŸ ืื™ืจ ืคึผืขืจืกื ืึทืœื™ ืคื™ืœืŸ ื•ื•ืขื’ืŸ ื“ืขื ืคืึทืงื˜ ืึทื– ืคื™ืœ ืคื•ืŸ ื•ื•ืึธืก ืื™ืจ ื˜ืึธืŸ ืื™ื– ื’ืขื ื™ืฆื˜ ื“ื•ืจืš ืื ื“ืขืจืข ื•ื•ืืœืงื ืก?" ืžื™ืจ ื•ื•ืขืœืŸ ื ื™ืฉื˜ ื ืึธืžืขืŸ ืกืคึผืขืฆื™ืคื™ืฉ ืึธื ืขืก, ืึธื‘ืขืจ ืคื™ืœืข ืคึผืจืึทื“ื–ืฉืขืงืก ื•ื•ืึธืก ื–ืขื ืขืŸ ื’ืขื˜ืืŸ ืื™ืŸ Yandex.Cloud ื–ืขื ืขืŸ ื’ืขื ื™ืฆื˜ ืื™ืŸ ืื ื“ืขืจืข ืžืขื ื˜ืฉืŸ ืก ื•ื•ืืœืงื ืก.

ื“ืึธืก ืื™ื– ืงื™ืœ. ืขืจืฉื˜ืขืจ, ืขืก ืื™ื– ืึท ืฆื™ื™ื›ืŸ ืึทื– ืžื™ืจ ื”ืึธื‘ืŸ ื’ืขื˜ืืŸ ืขืคึผืขืก ืจืขื›ื˜. ืื•ืŸ ืขืก ืกืงืจืึทื˜ืฉื™ื– ื“ื™ ื™ืš. ืื•ืŸ ืžื™ืจ ื–ืขื ืขืŸ ืžืขืจ ื–ื™ื›ืขืจ ืึทื– ืžื™ืจ ื”ืึธื‘ืŸ ื’ืขืžืื›ื˜ ื“ื™ ืจืขื›ื˜ ื‘ืึทืฉืœื•ืก. ืคึฟื•ืŸ ื“ืขืจ ืึทื ื“ืขืจืขืจ ื–ืฒึทื˜, ืื™ื– ื“ืึธืก ื“ื™ ื”ืึธืคืขื ื•ื ื’, ืึทื– ืื™ืŸ ื“ืขืจ ืฆื•ืงื•ื ืคึฟื˜ ื•ื•ืขื˜ ื“ืึธืก ืื•ื ื“ื– ื‘ืจืขื ื’ืขืŸ ื ืฒึทืข ืื™ื“ืขืขืŸ, ื ืฒึทืข ื‘ืขื˜ืŸ ืคึฟื•ืŸ ื“ืจื™ื˜-ืคึผืึทืจื˜ื™ื™ ื‘ืึทื ื•ืฆืขืจ. ืจื•ื‘ึฟ ื™ืฉื•ื– ืื•ื™ืฃ ื’ื™ื˜ื”ื•ื‘ ื–ืขื ืขืŸ ื‘ืืฉืืคืŸ ื“ื•ืจืš ื™ื—ื™ื“ ืกื™ืกื˜ืขื ืึทื“ืžื™ื ื™ืกื˜ืจืึทื˜ืึธืจืก, ื™ื—ื™ื“ ื“ื‘ืึท, ื™ื—ื™ื“ ืึทืจืงืึทื˜ืขืงืฅ, ื™ื—ื™ื“ ืขื ื“ื–ืฉืึทื ื™ืจื–, ืึธื‘ืขืจ ืžืืœ ืžืขื ื˜ืฉืŸ ืžื™ื˜ ืกื™ืกื˜ืขืžืึทื˜ื™ืฉ ื“ืขืจืคืึทืจื•ื ื’ ืงื•ืžืขืŸ ืื•ืŸ ื–ืึธื’ืŸ ืึทื– ืื™ืŸ 30% ืคื•ืŸ ื–ื™ื›ืขืจ ืงืึทืกืขืก ืžื™ืจ ื”ืึธื‘ืŸ ื“ืขื ืคึผืจืึธื‘ืœืขื ืื•ืŸ ืœืึธื–ืŸ ืื•ื ื“ื– ื˜ืจืึทื›ื˜ืŸ ื•ื•ืขื’ืŸ ื•ื•ื™ ืฆื• ืกืึธืœื•ื•ืข ืขืก. ื“ืึธืก ืื™ื– ื•ื•ืึธืก ืžื™ืจ ื–ืขื ืขืŸ ืงื•ืงืŸ ืคืึธืจื•ื™ืก ืฆื• ืจื•ื‘ึฟ. ืžื™ืจ ืงื•ืงืŸ ืคืึธืจื•ื™ืก ืฆื• ื™ื™ึทื ื˜ื™ื™ืœื•ื ื’ ื™ืงืกืคึผื™ืจื™ืึทื ืกื™ื– ืžื™ื˜ ืื ื“ืขืจืข ื•ื•ืึธืœืงืŸ ืคึผืœืึทื˜ืคืึธืจืžืก.

ืื™ืจ ื”ืึธื˜ ืึท ืกืš ื’ืขืจืขื“ื˜ ื•ื•ืขื’ืŸ ื“ืขื ืžืึทืจืึทื˜ื”ืึธืŸ. ืื™ืš ื•ื•ื™ื™ืก, ืึทื– ื“ื• ื‘ื™ืกื˜ ื’ืขืœืึธืคืŸ ืึท ืžืขืจืึทื˜ืึทืŸ ืื™ืŸ ืžืึธืกืงื•ื•ืข. ื•ื•ื™ ื ืจืขื–ื•ืœื˜ืื˜? ืึธื•ื•ื•ืขืจื˜ื•ืง ื“ื™ ื’ื™ื™ื– ืคึฟื•ืŸ PostgreSQL?

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

ืฆื™ ืื™ืจ ื–ืึธื’ืŸ ืึทื– ืขืก ื–ืขื ืขืŸ ืงื™ื™ืŸ ืจืึทื ืขืจื– ืื™ืŸ ClickHouse?

ืื™ืš ื•ื•ื™ื™ืก ื–ื™ื›ืขืจ ืื– ื–ื™ื™ ื–ืขื ืขืŸ ื“ืืจื˜. ืงืœื™ืงื›ืึธื•ืกืข ืื™ื– ืื•ื™ืš ืึท ื“ืึทื˜ืึทื‘ื™ื™ืก. ืื’ื‘, ืฉืจืฒึทื‘ื˜ ืžื™ืจ ืื™ืฆื˜ ืึธืœืขื’: โ€žืฆื™ ื•ื•ืขืœืŸ ืžื™ืจ ื’ื™ื™ืŸ ืึท ืœื•ื™ืฃ ื ืึธืš ื“ืขื ื‘ืึทืจื™ื›ื˜? ื“ืึธืก ืื™ื– ืึท ื’ืจื•ื™ืก ื’ืขื“ืึทื ืง.

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

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

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

ื“ืึธืก ืื™ื– ืึท ื˜ืฉื™ืงืึทื•ื•ืข ืงืฉื™ื: "ื•ื•ืื• ืฆื• ืึธื ื”ื™ื™ื‘ืŸ?" ืขืก ืื™ื– ื™ื•ื–ืฉืึทื•ื•ืึทืœื™ ื’ืึทื ืฅ ืฉื•ื•ืขืจ ืฆื• ืึธื ื”ื™ื™ื‘ืŸ ืžื™ื˜ ืขืคึผืขืก ืื™ืŸ ื“ื™ ืงืขืจืŸ. ืื™ืŸ Postgres, ืคึฟืึทืจ ื‘ื™ื™ึทืฉืคึผื™ืœ, ืขืก ืื™ื– ืึท ืฆื• ื˜ืึธืŸ ืจืฉื™ืžื”. ืื‘ืขืจ ืื™ืŸ ืคืึทืงื˜, ื“ืึธืก ืื™ื– ืึท ื‘ืœืึทื˜ ืคื•ืŸ ื•ื•ืึธืก ื–ื™ื™ ื’ืขืคืจื•ื•ื•ื˜ ืฆื• ื˜ืึธืŸ, ืึธื‘ืขืจ ืขืก ืื™ื– ื ื™ืฉื˜ ื’ืขืจืึธื˜ืŸ. ื“ืืก ื–ืขื ืขืŸ ืงืึธืžืคึผืœืขืงืก ื–ืื›ืŸ. ืื•ืŸ ื™ื•ื–ืฉืึทื•ื•ืึทืœื™ ืื™ืจ ืงืขื ืขืŸ ื’ืขืคึฟื™ื ืขืŸ ืขื˜ืœืขื›ืข ื™ื•ื˜ื™ืœืึทื˜ื™ื– ืื™ืŸ ื“ื™ ื™ืงืึธื•ืกื™ืกื˜ืึทื, ืขื˜ืœืขื›ืข ื™ืงืกื˜ืขื ืฉืึทื ื– ื•ื•ืึธืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ื™ืžืคึผืจื•ื•ื•ื“, ื•ื•ืึธืก ืฆื•ืฆื™ืขืŸ ื•ื•ื™ื™ื ื™ืงืขืจ ื•ืคืžืขืจืงื–ืึทืžืงื™ื™ื˜ ืคื•ืŸ ืงืขืจืŸ ื“ืขื•ื•ืขืœืึธืคึผืขืจืก. ืื•ืŸ, ืึทืงืึธืจื“ื™ื ื’ืœื™, ืขืก ื–ืขื ืขืŸ ืžืขืจ ืคื•ื ืงื˜ืŸ ืคึฟืึทืจ ื•ื•ื•ึผืงืก ื“ืึธืจื˜. ืื™ืŸ ื“ื™ Google Summer of Code ืคึผืจืึธื’ืจืึทื ื™ืขื“ืขืจ ื™ืึธืจ, ื“ื™ ืคึผืึธืกื˜ื’ืจืขืก ืงื”ืœ ืœื™ื™ื’ื˜ ืคืึธืจื•ื™ืก ืคื™ืœืข ืคืึทืจืฉื™ื“ืขื ืข ื˜ืขืžืขืก ื•ื•ืึธืก ืงืขืŸ ื–ื™ื™ืŸ ื’ืขืจืขื“ื˜. ื“ืึธืก ื™ืึธืจ ื”ืึธื‘ืŸ ืžื™ืจ ื’ืขื”ืึทื˜, ื“ืึทื›ื˜ ื–ื™ืš, ื“ืจืฒึท ืชึผืœืžื™ื“ื™ื. ืื™ื™ื ืขืจ ื”ืึธื˜ ืืคื™ืœื• ื’ืขืฉืจื™ื‘ืŸ ืื™ืŸ WAL-G ื•ื•ืขื’ืŸ ื˜ืขืžืขืก ื•ื•ืึธืก ื–ืขื ืขืŸ ื•ื•ื™ื›ื˜ื™ืง ืคึฟืึทืจ ื™ืึทื ื“ืขืงืก. ืื™ืŸ Greenplum, ืึทืœืฅ ืื™ื– ืกื™ืžืคึผืœืขืจ ื•ื•ื™ ืื™ืŸ ื“ื™ Postgres ืงื”ืœ, ื•ื•ื™ื™ึทืœ Greenplum ื›ืึทืงืขืจื– ืžื™ื™ึทื›ืœ ืฆื™ืขืŸ ืจื™ืงื•ื•ืขืก ื–ื™ื™ืขืจ ื’ื•ื˜ ืื•ืŸ ืึธื ื”ื™ื™ื‘ืŸ ืจื™ื•ื•ื™ื•ื™ื ื’ ื’ืœื™ื™ืš. ืฉื™ืงืŸ ืึท ืœืึทื˜ืข ืฆื• Postgres ืื™ื– ืึท ืขื ื™ืŸ ืคื•ืŸ ื—ื“ืฉื™ื, ืึธื‘ืขืจ Greenplum ื•ื•ืขื˜ ืงื•ืžืขืŸ ืื™ืŸ ืึท ื˜ืึธื’ ืื•ืŸ ื–ืขืŸ ื•ื•ืึธืก ืื™ืจ ื”ืึธื˜ ื’ืขื˜ืืŸ. ืืŸ ืื ื“ืขืจ ื–ืึทืš ืื™ื– ืึทื– ื’ืจื™ื ืคึผืœื•ื ื“ืึทืจืฃ ืกืึธืœื•ื•ืข ืงืจืึทื ื˜ ืคึผืจืึธื‘ืœืขืžืก. Greenplum ืื™ื– ื ื™ืฉื˜ ื•ื•ื™ื™ื“ืœื™ ื’ืขื ื™ืฆื˜, ืึทื–ื•ื™ ื’ืขืคึฟื™ื ืขืŸ ื“ื™ื™ืŸ ืคึผืจืึธื‘ืœืขื ืื™ื– ื’ืึทื ืฅ ืฉื•ื•ืขืจ. ืื•ืŸ ืขืจืฉื˜ืขืจ ืคื•ืŸ ืึทืœืข, ืžื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ืกืึธืœื•ื•ืข ืคึผืจืึธื‘ืœืขืžืก, ืคื•ืŸ ืงื•ืจืก.

ืžืงื•ืจ: www.habr.com