{"id":94417,"date":"2020-09-16T19:42:31","date_gmt":"2020-09-16T17:42:31","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/u-nas-tam-postgres-no-ya-hz-chto-s-nim-delat-s"},"modified":"2020-09-16T19:42:31","modified_gmt":"2020-09-16T17:42:31","slug":"u-nas-tam-postgres-no-ya-hz-chto-s-nim-delat-s","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/u-nas-tam-postgres-no-ya-hz-chto-s-nim-delat-s","title":{"rendered":"Meil on seal Postgres, aga ma ei tea, mida sellega teha (c)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
See, see, see, one of my acquaintances once asked me a question about Postgres. Back then, we solved his problem in a couple of days, and after thanking me, he added: 'It's good to have a DBA acquaintance.'<\/p>\n
Aga mis teha, kui tuttavat DBA ei ole? Vastuseid v\u00f5ib olla palju, alates s\u00f5prade seas otsimisest kuni k\u00fcsimuse ise lahendamiseni. Kuid \u00fcksk\u00f5ik milline vastus teile p\u00e4he tuleb, mul on teile hea uudis. Testre\u017eiimis oleme k\u00e4ivitanud Postgresi ja sellega seotud teenuste soovituste s\u00fcsteemi. Mis see on ja kuidas me selleni j\u00f5udsime?<\/p>\n
Milleks see k\u00f5ik?<\/h2>\n
Postgres ei ole v\u00e4hemalt lihtsalt, vaid m\u00f5nikord isegi v\u00e4ga keeruline. See s\u00f5ltub kaasamise ja vastutuse tasemest.<\/p>\n
Those in operations need to ensure that Postgres is functioning correctly and consistently as a service \u2014 monitoring resource utilization, availability, configuration adequacy, periodically performing updates, and regular health checks. For developers, it\u2019s essential to observe how the application interacts with the database and to avoid creating emergency situations that could crash it. If someone is unfortunate enough to be a tech lead\/tech director, it\u2019s vital that Postgres overall operates reliably and predictably without causing issues, preferably without having to delve deeply into Postgres for extended periods.<\/p>\n
Igasugustes olukordades oled sina ja Postgres. Et Postgres't h\u00e4sti hallata, tuleb selle korralikult m\u00f5ista ja teada, kuidas see t\u00f6\u00f6tab. Kui Postgres ei ole otse teie spetsialiseerumine, v\u00f5ib selle \u00f5ppimine v\u00f5tta palju aega. Ideaalses olukorras, kus on aega ja soovi, aga ei pruugi alati olla selge, kust alustada, kuidas ja kuhu liikuda.<\/p>\n
Isegi kui kasutada j\u00e4lgimist, mis peaks ideaalis h\u00f5lbustama toimimist, j\u00e4\u00e4b ekspertteadmiste k\u00fcsimus avatuks. Selleks, et osata lugeda ja m\u00f5ista graafikuid, on endiselt vajalik hea arusaam sellest, kuidas Postgres t\u00f6\u00f6tab. Vastasel juhul muutub mis tahes j\u00e4lgimine kurvaks pildiks ja sp\u00e4mmiks h\u00e4iretest juhuslikel p\u00e4evakelladel.<\/p>\n