Sisebenza njengo umphathi wedatha Oracle a:
Milan, Bergamo, Brescia, Varese, Como, Cremona , ILecco, Mantova, Pavia, Sondrio, kodwa futhi siyasebenza,
Abruzzo : U-Akhwila , Chieti , Pescara , Teramo
Basilicata : Matera , amandla
Calabria : Catanzaro , Cosenza , Crotone , Reggio Calabria , I-Vibo Valentia
I-Campania : I-Avellino , Benevento , I-Caserta , Naples , I-Salerno
Emilia Romagna : Bologna , Ferrara , Forlì , Cesena , Modena , Parma , Piacenza, I-Ravenna , Reggio Emilia , Rimini
Friuli Venezia Giulia : IGorizia , I-Pordenone , Trieste , Udine
Lazio : Frosinone , Latina , Rieti , amaRom , IViterbo
I-Liguria : Genoa , Imperia , Spice , Savona
Lombardy : Bergamo , Brescia , Como , Cremona , ILecco , Mantova , Milan , Pavia , Sondrio , Varese
UMarche : Ancona , I-Ascoli Piceno , Macerata , I-Pesaro , I-Urbino
Molise : Campobasso , Isernia
Piedmont : Alessandria , Asti , UBiella, Cuneo , I-Novara , eTurin , I-Vercelli
I-Puglia : Bari , Brindisi , Foggia, Lecce , Taranto
I-Sardegna : Cagliari , ICarbonia , Amasonto , I-Nuoro , I-Ogliastra, Olbia , Ithempeli , Oristano , Sassari
Sicilia : I-Agrigento , I-Caltanissetta , Catania , Enna , Messina , Palermo , I-Ragusa , Syracuse , Trapani , Marsala , Mazara del vallo, I-Pantelleria
Tuscany : Arezzo , Florence , I-Grosseto , ILivorno , Lucca , UMassa Carrara , I-Pisa , Pistoia , Prato , Siena
UTrentino Alto Adige : Bolzano , Ukulandela
I-Veneto : Belluno , I-Padova , I-Rovigo , I-Treviso , I-Venezia , Verona , UVicenza
Svizzera: Lugano, Canton of Ticino, UBellinzona, I-Locarno, UMendrisio, umsindo.
I-postgresql DBA
Isikhulu esiphezulu uStefano Fantin ufunde ikhodi yomthombo we I-DBMS I-Postgresql isuka ku-Postgresql inguqulo 8 yafika ku-Postgresql 9.5, siguqukele kunguqulo 10 futhi inguqulo 11 yaphuma inguqulo ye-Postgresql 12. Iwebhusayithi ejensi ye-inthanethi utshala isikhathi nemali ocwaningweni nasekuthuthukisweni kwe-Postgresql 13.
I-DBA EKUDE I-POSTGRESQL:
I-DBA ekude I-Postgresql 8.0: I-PITR, i-Tablespaces, i-Windows Support, i-Savepoints
I-DBA ekude I-Postgresql 8.1: Ukuhlukaniswa kwethebula, ukuskena kwe-Bitmap, ukwenza izigaba ezimbili, i-autovacuum
I-DBA ekude I-Postgresql 8.2: I-Warm Standby, i-SQL 2003, i-Concurrent Index Builds, izinkomba ze-Gin
I-DBA ekude I-Postgresql 8.3: Izibuyekezo ezishisayo, ukuzibophezela kwe-Asynchronous, i-XML, ukusesha kombhalo ogcwele, izindawo zokuhlola ezisabalalisiwe
I-DBA ekude I-Postgresql 8.4: Imisebenzi yeWindows, CTEs, Database amaqoqo, imvume yekholomu ngayinye
I-DBA ekude I-Postgresql 9.0: Okulindile Okushisayo, Ukuphindaphinda Kokusakaza, Izibangeli Zekholomu, Izibangeli ezinemibandela, i-hstore
I-DBA ekude I-Postgresql 9.1: Ukuphindaphinda Okuvumelanayo, Ama-CTE Abhalwayo, Isandiso, Izisonga Zedatha Yangaphandle, Amathebula Angalogiwe, Ukuhlukaniswa Kwesifinyezo Esiqhubekayo, Ukuhlanganisa Ikholomu
I-DBA ekude I-Postgresql 9.2: Ukuphindaphinda kwe-Cascading, ukuskena kwe-Index-Only, pg_stat_statements, Json, Ranges
I-DBA ekude I-Postgresql 9.3: Izisonga Zedatha Yangaphandle Ebhalwayo, Ukubuka Kwempahla, imisebenzi ye-JSON nama-opharetha, LATERAL
I-DBA ekude I-Postgresql 9.4: Ukuphindaphinda okunengqondo, izikhala zokuphindaphinda, i-JSONB -> I-GIN (Inkomba Eguquliwe Ejwayelekile), ukukala: Ukuqoshwa Okunengqondo
I-DBA ekude I-Postgresql 9.5: I-UPSERT, ukuphepha kwezinga lomugqa, ukusebenza kwe Idatha enkulu: Inkomba ye-BRIN, i-algorithm ebizwa ngokuthi "okhiye abafushanisiwe", CUBE, ROLLUP, kanye ne-GROUPING SET, TABLESAMPLE, Izisonga Zedatha Yangaphandle (FDW)
I-DBA ekude I-Postgresql 9.6 : Khuphula ngemibuzo ehambisanayo, Khipha ngokuphindaphinda okuvumelanayo kanye ne-'postgres_fdw', Ukusesha umbhalo okuthuthukisiwe ngemishwana. Umbuzo Ohambisanayo : Ukuskena okulandelanayo okuhambisanayo, ukuhlanganisa okuhambisanayo, ukuhlanganisa okuhambisanayo.
Okwenziwayo, i-VACUUM kanye Nemephu Ebonakalayo: pg_visibility extension yokuhlola ukubonakala kwamamephu, Idatha yekhasi eliqandisiwe kumephu ebonakalayo yokweqa i-vacuum kudatha esivele iqandisiwe, Ukuphelelwa yisikhathi okuchazwe umsebenzisi kwezifinyezo ukuze kulawuleke ukufiphala kwethebula. Ukusebenza nokuqapha:
Imininingwane yokulinda enemininingwane ku-pg_stat_activity, Izikena ze-Index kuphela zezinkomba ezingaphelele, Ukuthuthukiswa kokusebenza kokusebenza kokuhlunga kwangaphandle. Ukubuka Kwesistimu Nokuphatha: Ukubuka kwesistimu entsha pg_config, pg_blocking_pids, Imisebenzi pg_get_ * ukubuyisela NULL kokungavumelekile
izinto, pg_notification_queue_usage ukubheka ulayini wokwazisa. Izipele : pg_basebackup inwetshiwe ngezikhala zokuphindaphinda, i-API entsha yezipele ezishisayo zomzimba. Ezinye izici: Ukubikwa kwenqubekela-phambili yomyalo, indawo ye-WAL ejwayelekile, imisebenzi ye-Trigonometric ngamadigri.
HHAYI KUPHELA LABASEDUZE KUTHI BASIKHETHA.
Thola okuningi ku-Online Web Agency
Bhalisa ukuze uthole izindatshana zakamuva nge-imeyili.