Sisebenza ngathi umlawuli weenkcukacha Oracle a:
Milano, Bergamo, Brescia, Varese, Como, Cremona , Lecco, Mantova, Pavia, Sondrio, kodwa siyasebenza,
Abruzzo : Akwila , Chieti , Pescara , Teramo
Basilicata : Matera , Potenza
labria : ICatanzaro , ICosenza , Crotone , Reggio Calabria , UVibo Valentia
Campania : Avellino , Benevento , Caserta , Naples , I-Salerno
Emilia Romagna : Bologna , UFerrara , Forlì , Cesena , Modena , Parma , Piacenza, I-Ravenna , UReggio Emilia , Rimini
UFriuli Venezia Giulia : Gorizia , His hisque hisque hisquequequequeque hisquequeque hisqueque following , Trieste , Udine
Lazio : Frosinone , Latina , Rieti , eRoma , IViterbo
Liguria : Genoa , Imperia , Spice , Savona
Lombardia : Bergamo , Brescia , Como , Cremona , Lecco , Mantova , Milano , Pavia , Sondrio , Varese
Ukuhamba : Ancona , UAscoli Piceno , Macerata , I-Pesaro , Urbino
Molise : ICampobasso , Isernia
Piedmont : Alessandria , Asti , Biella, Cuneo , Novara , eTurin , IVercelli
Puglia : Bari , Brindisi , Foggia, Lecce , Taranto
eSardinia : Cagliari , ICarbonia , Iicawa , I-Nuoro , I-Ogliastra, Olbia , Itempile , Oristano , Sassari
sicilià : IAgrigento , ICaltanissetta , Catania , Enna , UMessina , Palermo , Ragusa , eSirakusa , Trapani , Marsala , Mazara del vallo, I-Pantelleria
Tuscany : I-Arezzo , Florence , Grosseto , ILivorno , Lucca , UMassa Carrara , Pisa , Pistoia , Prato , Siena
UTrentino Alto Adige : Bolzano , Ukuya
Veneto : Belluno , Padova , URovigo , Treviso , Venezia , IVerona , Vicenza
Svizzera: Lugano, kwiCanton yaseTicino, UBellinzona, Indawo, i-endrisio, ingxolo.
Postgresql DBA
I-CEO uStefano Fantin uye wafunda ikhowudi yomthombo we I-DBMS I-Postgresql ukusuka kwi-Postgresql inguqulo ye-8 ukuya kwi-Postgresql 9.5, siye savela kwinguqulo ye-10 kunye nenguqulo ye-11 yaphuma kwi-Postgresql 12 version. Umnxibelelanisi wewebhu kwi-Intanethi utyala ixesha kunye nemali kuphando kunye nophuhliso kwi-Postgresql 13.
I-REMOTE DBA I-POSTGRESQL:
Ekude DBA I-Postgresql 8.0 : I-PITR, i-Tablespaces, iNkxaso yeWindows, i-Savepoints
Ekude DBA I-Postgresql 8.1 : Ukwahlulahlula kwetheyibhile, ukuskena kweBitmap, ukwenza iSigaba eSibini, i-autovacuum
Ekude DBA I-Postgresql 8.2 : Ukulinda okufudumeleyo, iSQL ka-2003, iSalathi esiNyenyeneyo esakhayo, izalathisi ze-Gin
Ekude DBA I-Postgresql 8.3 : Uhlaziyo olushushu, ukuzibophelela kwe-Asynchronous, i-XML, ukukhangela umbhalo ogcweleyo, iindawo zokujonga ezisasaziweyo
Ekude DBA I-Postgresql 8.4 : imisebenzi yeWindows, CTEs, database izivumelwano, Per-Column imvume
Ekude DBA I-Postgresql 9.0 : I-Hot Standby, ukuphindaphinda ukusasazwa, iziQinisekisi zeKholamu, iziQinisekiso ezinoMqathango, i-hstore
Ekude DBA I-Postgresql 9.1 : Uphindaphindo oluQhagamshelweyo, ii-CTE eziBhalwayo, Ulwandiso, Izisongelo zeDatha yaNgaphandle, iitafile ezingabhalwanga, Ukwahlulwa kweSnapshot esiSetyenzwayo, ukuHlangana kweKholam.
Ekude DBA I-Postgresql 9.2 : I-Cascading Replication, i-Index-Only scans, pg_stat_statements, Json, Ranges
Ekude DBA I-Postgresql 9.3 : I-Wrappers yeeNkcukacha zaNgaphandle eziBhalwayo, iiMbono zeMathiriyeli, imisebenzi ye-JSON kunye nabaqhubi, LATERAL
Ekude DBA I-Postgresql 9.4 : Ukuphindaphinda okusengqiqweni, iindawo zokuphindaphinda, i-JSONB-> I-GIN (iSalathisi esiGuquliweyo Jikelele), ukukala : Ukwenziwa kweKhowuwudi okuNgengqiqo
Ekude DBA I-Postgresql 9.5 : I-UPSERT, ukhuseleko lwenqanaba lomqolo, ukusebenza kwe Idatha enkulu: Isalathiso se-BRIN, i-algorithm ebizwa ngokuba "izitshixo ezishunqulelweyo", CUBE, ROLLUP, kunye ne-GROUPING SET, TABLESAMPLE, Izisongelo zeDatha zaNgaphandle (FDW)
Ekude DBA Postgresql 9.6: Linganisa ngokusebenzisa imibuzo enxuseneyo, Khipha ngokuphindaphinda okulandelelanayo kunye ne-'postgres_fdw', Ukukhangela okubhaliweyo okuphuculweyo ngamabinzana. Umbuzo onxuseneyo : Ukuskena okulandelelanayo okunxuseneyo, izidibanisi ezinxuseneyo, iiaggregates ezinxuseneyo.
Iintengiselwano, i-VACUUM kunye neMaphu yokuBoneka : pg_ukwandiswa kokubonakala kokuhlola ukubonakala kweemephu, Idatha yephepha elifriziweyo kwimephu yokubonakala ukuze utsibe i-vacuum kwidatha esele ikhenkcezisiwe, Ukuphela kwexesha elichazwe ngumsebenzisi lee-snapshots ukulawula i-bloat yetafile. Ukusebenza kunye nokuBeka iliso :
Iinkcukacha zokulinda ezineenkcukacha kwi-pg_stat_activity, i-Index-kuphela iskena sezalathisi ezingaphelelanga, Uphuculo lwentsebenzo yemisebenzi yohlobo lwangaphandle. IiJongo zeNkqubo kunye noLawulo : Indlela entsha yokujonga i-pg_config, pg_blocking_pids, Imisebenzi pg_get_* ukubuyisela i-NULL kwi-invalid
izinto, pg_notification_queue_usetyenziso ukujonga umgca wokwazisa. Ugcino : pg_basebackup eyandisiweyo eneendawo zokuphindaphinda, i-API entsha yee-backups zomzimba ezishushu. Ezinye iimpawu: Umyalelo wokunika ingxelo ngenkqubela phambili, ifasilithi ye-WAL eqhelekileyo, imisebenzi ye-Trigonometric ngezidanga.
HAYI KUPHELA ABASondele KUWE BASIKHETHAYO.
Fumana okungakumbi kwi-Arhente yeWebhu ye-Intanethi
Bhalisa ukuze ufumane amanqaku amva nje nge-imeyile.