{"id":72875,"date":"2020-03-05T08:42:09","date_gmt":"2020-03-05T05:42:09","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/zdorove-indeksov-v-postgresql-glazami-java-razrabotchika"},"modified":"2020-03-05T08:42:09","modified_gmt":"2020-03-05T05:42:09","slug":"zdorove-indeksov-v-postgresql-glazami-java-razrabotchika","status":"publish","type":"post","link":"https:\/\/prohoster.info\/bs\/blog\/administrirovanie\/zdorove-indeksov-v-postgresql-glazami-java-razrabotchika","title":{"rendered":"Zdravlje indeksa u PostgreSQL o\u010dima Java programera","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Zdravo.<\/p>\n<p><\/p>\n<p>Zovem se Ivan i ja sam Java developer. Tako se dogodi da puno radim s PostgreSQL-om \u2013 bavim se pode\u0161avanjem baza podataka, optimizacijom strukture, performansi i pomalo igram DBA-a tokom vikenda.<\/p>\n<p><\/p>\n<p>U poslednje vreme sam doveo u red nekoliko baza podataka u na\u0161im mikroservisima i napisao java biblioteku <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health\">pg-index-health<\/a><\/noindex>, koja olak\u0161ava ovaj posao, \u0161tedi moje vreme i poma\u017ee da izbegnem neke uobi\u010dajene gre\u0161ke koje prave programeri. O ovoj biblioteci \u0107e danas biti re\u010di.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Zdravlje indeksa u PostgreSQL o\u010dima Java programera\" src=\"\/wp-content\/uploads\/2020\/03\/e00bd48edf601f398bd7748754d48b80.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<h3 id=\"disclaimer\">Odricanje od odgovornosti<\/h3>\n<p><\/p>\n<p>Glavna verzija PostgreSQL-a sa kojom radim je 10. Sve SQL upite koje koristim sam tako\u0111e proverio na 11. verziji. Minimalno podr\u017eavana verzija je 9.6.<\/p>\n<p><\/p>\n<h3 id=\"predystoriya\">Pozadina<\/h3>\n<p><\/p>\n<p>Sve je po\u010delo pre skoro godinu dana sa situacijom koja mi je bila \u010dudna: konkurentno kreiranje indeksa na ravnom terenu zavr\u0161ilo je gre\u0161kom. Sam indeks je, kao \u0161to to obi\u010dno biva, ostao u neva\u017ee\u0107em stanju u bazi. Analizom logova je otkriveno da nedostaje <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/10\/runtime-config-resource\">temp_file_limit<\/a><\/noindex>. I onda je krenulo... Kada sam dublje kopao, otkrio sam \u010ditav niz problema u konfiguraciji baze podataka, i, zamu\u0107uju\u0107i rukave, sa sjajem u o\u010dima, po\u010deo da ih otklanjam.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h3 id=\"problema-pervaya--defoltnaya-konfiguraciya\">Prvi problem \u2013 podrazumevana konfiguracija<\/h3>\n<p><\/p>\n<p>Verovatno, metafora o Postgresu koji se mo\u017ee pokrenuti na kafi\u0107u je svima ve\u0107 dosadila, ali... podrazumevana konfiguracija zaista postavlja nekoliko pitanja. Kao minimum, treba obratiti pa\u017enju na <strong>maintenance_work_mem<\/strong>, <strong>temp_file_limit<\/strong>, <strong>statement_timeout<\/strong> i <strong>lock_timeout<\/strong>.<\/p>\n<p><\/p>\n<p>U na\u0161em slu\u010daju <strong>maintenance_work_mem<\/strong> je podrazumevano bilo 64 MB, dok je <strong>temp_file_limit<\/strong> ne\u0161to oko 2 GB \u2013 jednostavno nam je nedostajalo memorije za kreiranje indeksa na velikoj tabeli.<\/p>\n<p><\/p>\n<p>Zato sam u <strong>pg-index-health<\/strong> sastavio niz <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health\/blob\/dfbc7a37fc9c5f82957eeacdacd29a713fff7f51\/src\/main\/java\/io\/github\/mfvanek\/pg\/settings\/ImportantParam.java#L14\">klju\u010dnih<\/a><\/noindex>, po mom mi\u0161ljenju, parametara koje treba podesiti za svaku bazu podataka.<\/p>\n<p><\/p>\n<h3 id=\"problema-vtoraya--dubliruyuschiesya-indeksy\">Drugi problem \u2013 duplicirani indeksi<\/h3>\n<p><\/p>\n<p>Na\u0161e baze se nalaze na SSD diskovima, i koristimo <em>HA<\/em>-konfiguraciju sa vi\u0161e data centara, master hostom i <em>n<\/em>-tim brojem replika. Prostor na disku je veoma dragocen resurs za nas; on je jednako va\u017ean kao performanse i potro\u0161nja CPU-a. Zato, s jedne strane, potrebni su nam indeksi za brzo \u010ditanje, a s druge strane, ne \u017eelimo videti suvi\u0161ne indekse u bazi, jer oni tro\u0161e prostor i usporavaju a\u017euriranje podataka.<\/p>\n<p><\/p>\n<p>I tako, obnoviv\u0161i sve <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health\/blob\/master\/src\/main\/resources\/sql\/invalid_indexes.sql\">neva\u017ee\u0107e indekse<\/a><\/noindex> i nagledav\u0161i se <noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=aaecM4wKdhY\">izvje\u0161taja Olega Bartunova<\/a><\/noindex>, odlu\u010dio sam napraviti \"veliku\" \u010distku. Ispostavilo se da programeri ne vole \u010ditati dokumentaciju o bazi podataka. Jako ne vole. Zbog toga nastaju dvije tipi\u010dne gre\u0161ke \u2013 ru\u010dno stvoren indeks na primarni klju\u010d i sli\u010dan \"ru\u010dni\" indeks na jedinstveni stupac. Stvar je u tome da nisu potrebni \u2013 Postgres \u0107e sve u\u010diniti sam. Takve indekse se mo\u017ee slobodno ukloniti, a za to postoji dijagnostika <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health\/blob\/master\/src\/main\/resources\/sql\/duplicated_indexes.sql\">duplicated_indexes<\/a><\/noindex>.<\/p>\n<p><\/p>\n<h3 id=\"problema-tretya--peresekayuschiesya-indeksy\">Tre\u0107i problem \u2013 preklapaju\u0107i indeksi<\/h3>\n<p><\/p>\n<p>Ve\u0107ina po\u010detnih programera stvara indekse na jedan stupac. Postupno, dok se upoznaju s tim, ljudi po\u010dinju optimizirati svoje upite i dodavati slo\u017eenije indekse koji uklju\u010duju vi\u0161e stupaca. Tako nastaju indeksi na stupce <em>A<\/em>, <em>A+B<\/em>, <em>A+B+C<\/em> itd. Prva dva od ovih indeksa se mo\u017ee slobodno baciti, jer su prefiksi tre\u0107eg. To tako\u0111er zna\u010dajno \u0161tedi prostor na disku i za to postoji dijagnostika <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health\/blob\/master\/src\/main\/resources\/sql\/intersected_indexes.sql\">intersected_indexes<\/a><\/noindex>.<\/p>\n<p><\/p>\n<h3 id=\"problema-chetvertaya--vneshnie-klyuchi-bez-indeksov\">\u010cetvrti problem \u2013 strani klju\u010devi bez indeksa<\/h3>\n<p><\/p>\n<p>Postgres omogu\u0107uje stvaranje ograni\u010denja stranog klju\u010da bez navo\u0111enja podr\u017eavaju\u0107eg indeksa. U mnogim situacijama to nije problem i \u010dak se mo\u017eda ne\u0107e ni manifestirati... Do jednog trenutka...<\/p>\n<p><\/p>\n<p>Tako je bilo i kod nas: samo je u nekom trenutku posao, koji se izvr\u0161avao prema rasporedu i \u010distio bazu od testnih narud\u017ebi, po\u010deo \"slagati\" nam majstora host. CPU i IO su opali, upiti su usporeni i prekidani zbog vremenskog ograni\u010denja, servis se ru\u0161io. Brza analiza <noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgresql\/10\/monitoring-stats\">pg_stat_activity<\/a><\/noindex> je pokazala da su se usporavali upiti ovog tipa:<\/p>\n<p><\/p>\n<pre><code class=\"sql\">izbri&scaron;i iz &lt;table&gt; gdje je id u (&hellip;)<\/code><\/pre>\n<p><\/p>\n<p>Prilikom toga, indeks po id-u u ciljoj tablici, naravno, je postojao, i zapisi su se brisali prema uvjetu sasvim malo. \u010cinilo se da sve treba raditi, ali, na\u017ealost, nije.<\/p>\n<p><\/p>\n<p>U pomo\u0107 je do\u0161ao \u010dudesni <strong>explain analyze<\/strong> i rekao da osim brisanja zapisa u ciljnoj tablici, jo\u0161 ide provjera referentne cjelovitosti, i na jednoj od povezanih tablica ta provjera pada u <em>sequential scan<\/em> zbog nedostatka odgovaraju\u0107eg indeksa. Tako je ro\u0111ena dijagnostika <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health\/blob\/master\/src\/main\/resources\/sql\/foreign_keys_without_index.sql\">foreign_keys_without_index<\/a><\/noindex>.<\/p>\n<p><\/p>\n<h3 id=\"problema-pyataya--null-value-v-indeksah\">Peti problem \u2013 null vrijednosti u indeksima<\/h3>\n<p><\/p>\n<p>Zadano, Postgres uklju\u010duje null vrijednosti u btree-indekse, ali one su obi\u010dno nepotrebne. Stoga nastojim ukloniti te null-ove (dijagnostika <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health\/blob\/master\/src\/main\/resources\/sql\/indexes_with_null_values.sql\">indexes_with_null_values<\/a><\/noindex>), stvaraju\u0107i parcijalne indekse na nullable-stupcima poput <code>where <A> is not null<\/code>. Na ovaj na\u010din uspio sam smanjiti veli\u010dinu jednog od na\u0161ih indeksa sa 1877 MB na 16 KB. A u jednoj usluzi veli\u010dina DB-a se ukupno smanjila za 16% (za 4,3 GB u apsolutnim brojkama) isklju\u010divanjem null vrijednosti iz indeksa. Ogromna u\u0161teda prostora na disku uz prili\u010dno jednostavne dorade. \ud83d\ude42 <\/p>\n<p><\/p>\n<h3 id=\"problema-shestaya--otsutstvie-pervichnyh-klyuchey\">\u0160esti problem \u2013 nedostatak primarnih klju\u010deva<\/h3>\n<p><\/p>\n<p>Zbog karakteristika mehanizma <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/postgrespro\/blog\/442804\/\">MVCC u Postgresu<\/a><\/noindex> mo\u017ee do\u0107i do situacije kao <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/169939\/\">bloat<\/a><\/noindex>, kada veli\u010dina va\u0161e tabele brzo raste zbog velikog broja mrtvih zapisa. Naivno sam mislio da nam to ne prijeti i da se to ne\u0107e desiti na\u0161oj bazi, jer smo, uostalom!!!, dobri programeri... Kako sam bio glup i naivan\u2026<\/p>\n<p><\/p>\n<p>Jednog lijepog dana, jedna divna migracija je a\u017eurirala sve zapise u velikoj i aktivno kori\u0161tenoj tabeli. Dobili smo +100 GB na veli\u010dini tabele niotkuda. Bilo je izuzetno frustriraju\u0107e, ali na\u0161i problemi tu nisu zavr\u0161ili. Nakon \u0161to je automatska vakuumacija na ovoj tabeli zavr\u0161ena za 15 sati, postalo je jasno da fizi\u010dko mjesto ne\u0107e biti vra\u0107eno. Nismo mogli zaustaviti servis i uraditi VACUUM FULL, pa je donesena odluka da se koristi <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/reorg\/pg_repack\">pg_repack<\/a><\/noindex>. I tu se pokazalo da <em>pg_repack<\/em> ne mo\u017ee obraditi tabele bez primarnog klju\u010da ili drugog ograni\u010denja jedinstvenosti, a na na\u0161oj tabeli nije bilo primarnog klju\u010da. Tako je nastala dijagnostika <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health\/blob\/master\/src\/main\/resources\/sql\/tables_without_primary_key.sql\">tables_without_primary_key<\/a><\/noindex>.<\/p>\n<p><\/p>\n<p>U verziji biblioteke <strong>0.1.5<\/strong> dodana je mogu\u0107nost prikupljanja podataka o bloatu tabela i indeksa i pravovremeno reagovanje na njega.<\/p>\n<p><\/p>\n<h3 id=\"problemy-sem-i-vosem--nehvatka-indeksov-i-neispolzuemye-indeksy\">Problemi sedam i osam \u2013 nedostatak indeksa i neiskori\u0161teni indeksi<\/h3>\n<p><\/p>\n<p>Sljede\u0107e dijagnostike su <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health\/blob\/master\/src\/main\/resources\/sql\/tables_with_missing_indexes.sql\">tables_with_missing_indexes<\/a><\/noindex> i <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health\/blob\/master\/src\/main\/resources\/sql\/unused_indexes.sql\">unused_indexes<\/a><\/noindex> \u2013 u svom kona\u010dnom obliku pojavili su se relativno nedavno. Stvar je u tome \u0161to ih nije bilo mogu\u0107e jednostavno tako dodati.<\/p>\n<p><\/p>\n<p>Kao \u0161to sam ve\u0107 pisao, koristimo konfiguraciju sa vi\u0161e replika, i optere\u0107enje pri \u010ditanju na razli\u010ditim hostovima je su\u0161tinski razli\u010dito. U kona\u010dnici, dolazi do situacije da se odre\u0111ene tabele i indeksi na odre\u0111enim hostovima prakti\u010dno ne koriste, i za analizu je potrebno prikupiti statistiku sa svih hostova u klasteru. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health\/blob\/dfbc7a37fc9c5f82957eeacdacd29a713fff7f51\/src\/main\/java\/io\/github\/mfvanek\/pg\/index\/health\/IndexesHealth.java#L165\">Resetovanje statistike<\/a><\/noindex> tako\u0111e treba vr\u0161iti na svakom hostu u klasteru, ne mo\u017ee se to u\u010diniti samo na masteru.<\/p>\n<p><\/p>\n<p>Ovaj pristup nam je omogu\u0107io da u\u0161tedimo nekoliko desetina gigabajta uklanjanjem indeksa koji nikada nisu kori\u0161\u0107eni, kao i da dodamo nedostaju\u0107e indekse na retko kori\u0161\u0107ene tabele.<\/p>\n<p><\/p>\n<h3 id=\"v-kachestve-zaklyucheniya\">Kao zaklju\u010dak<\/h3>\n<p><\/p>\n<p>Naravno, gotovo za sve dijagnostike mogu se podesiti <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health\/blob\/dfbc7a37fc9c5f82957eeacdacd29a713fff7f51\/src\/main\/java\/io\/github\/mfvanek\/pg\/index\/health\/logger\/Exclusions.java#L26\">spisak izuzetaka<\/a><\/noindex>. Na ovaj na\u010din se brzo mogu implementirati provere u va\u0161oj aplikaciji, spre\u010davaju\u0107i pojavu novih gre\u0161aka, a zatim postepeno ispraviti stare.<\/p>\n<p><\/p>\n<p>Neki dijagnosti\u010dki testovi mogu se izvoditi ve\u0107 u funkcionalnim testovima odmah nakon primene migracija baze podataka. I to je verovatno jedna od najmo\u0107nijih mogu\u0107nosti moje biblioteke. Primer kori\u0161\u0107enja mo\u017eete pogledati u <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mfvanek\/pg-index-health-demo\/blob\/master\/src\/test\/java\/io\/github\/mfvanek\/pg\/index\/health\/demo\/IndexesMaintenanceTest.java\">demonstracija<\/a><\/noindex>.<\/p>\n<p><\/p>\n<p>Provere za neiskori\u0161\u0107ene ili nedostaju\u0107e indekse, kao i za bloat, ima smisla izvr\u0161avati samo na stvarnoj bazi podataka. Prikupljene vrednosti mogu se zabele\u017eiti u <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ClickHouse\/ClickHouse\">ClickHouse<\/a><\/noindex> ili poslati u sistem za nadzor.<\/p>\n<p><\/p>\n<p>Veoma se nadam da <strong>pg-index-health<\/strong> \u0107e biti korisna i tra\u017eena. Tako\u0111e mo\u017eete doprineti razvoju biblioteke izve\u0161tavaju\u0107i o otkrivenim problemima i predla\u017eu\u0107i nove dijagnostike.<\/p>\n<p>Izvor: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/490824\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u0440\u0438\u0432\u0435\u0442. \u041c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0412\u0430\u043d\u044f, \u0438 \u044f Java-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a. \u0422\u0430\u043a \u043f\u043e\u043b\u0443\u0447\u0438\u043b\u043e\u0441\u044c, \u0447\u0442\u043e \u044f \u043c\u043d\u043e\u0433\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u044e \u0441 PostgreSQL \u2013 \u0437\u0430\u043d\u0438\u043c\u0430\u044e\u0441\u044c \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u043e\u0439 \u0411\u0414, \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b, \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e \u0438 \u043d\u0435\u043c\u043d\u043e\u0433\u043e \u0438\u0433\u0440\u0430\u044e \u0432 DBA \u043f\u043e \u0432\u044b\u0445\u043e\u0434\u043d\u044b\u043c. \u0417\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0435 \u0432\u0440\u0435\u043c\u044f \u044f \u043f\u0440\u0438\u0432\u0451\u043b \u0432 \u043f\u043e\u0440\u044f\u0434\u043e\u043a \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u043d\u0430\u0448\u0438\u0445 \u043c\u0438\u043a\u0440\u043e\u0441\u0435\u0440\u0432\u0438\u0441\u0430\u0445 \u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043b java-\u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0443 pg-index-health, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043e\u0431\u043b\u0435\u0433\u0447\u0430\u0435\u0442 \u044d\u0442\u0443 \u0440\u0430\u0431\u043e\u0442\u0443, \u044d\u043a\u043e\u043d\u043e\u043c\u0438\u0442 \u043c\u043e\u0451 \u0432\u0440\u0435\u043c\u044f \u0438 \u043f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":72876,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-72875","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u0440\u0438\u0432\u0435\u0442. \u041c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0412\u0430\u043d\u044f, \u0438 \u044f Java-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/bs\/blog\/administrirovanie\/zdorove-indeksov-v-postgresql-glazami-java-razrabotchika\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"bs_BA\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0417\u0434\u043e\u0440\u043e\u0432\u044c\u0435 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432 \u0432 PostgreSQL \u0433\u043b\u0430\u0437\u0430\u043c\u0438 Java-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u0440\u0438\u0432\u0435\u0442. \u041c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0412\u0430\u043d\u044f, \u0438 \u044f Java-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/bs\/blog\/administrirovanie\/zdorove-indeksov-v-postgresql-glazami-java-razrabotchika\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-03-05T05:42:09+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-03-05T05:42:09+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Zdravlje indeksa u PostgreSQL o\u010dima Java programera | ProHoster","description":"Zdravo. Zovem se Vanya i ja sam Java programer.","canonical_url":"https:\/\/prohoster.info\/bs\/blog\/administrirovanie\/zdorove-indeksov-v-postgresql-glazami-java-razrabotchika","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"bs_BA","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0417\u0434\u043e\u0440\u043e\u0432\u044c\u0435 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432 \u0432 PostgreSQL \u0433\u043b\u0430\u0437\u0430\u043c\u0438 Java-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430 | ProHoster","og:description":"\u041f\u0440\u0438\u0432\u0435\u0442. \u041c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0412\u0430\u043d\u044f, \u0438 \u044f Java-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a.","og:url":"https:\/\/prohoster.info\/bs\/blog\/administrirovanie\/zdorove-indeksov-v-postgresql-glazami-java-razrabotchika","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-03-05T05:42:09+00:00","article:modified_time":"2020-03-05T05:42:09+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"72875","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 18:43:29","updated":"2022-09-27 23:10:08","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts\/72875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/comments?post=72875"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts\/72875\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/media\/72876"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/media?parent=72875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/categories?post=72875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/tags?post=72875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}