Hana mākou e like luna hoʻomalu hōkeo ʻikepili Oracle ma:
Milan, Bergamo, Brescia, Varese, Como, Cremona , Lecco, Mantua, Pavia, Sondrio, aka, ke hana nei makou,
Abruzzo : Akula , Chieti , Pescara , Teramo
Basilicata : Matera , ʻO Potenza
Calabria : Catanzaro , Cosenza , Crotone , ʻO Reggio Calabria , Vibo Valentia
Campania : Avellino , Benevento , Caserta , Napela , Salerno
Emilia Romagna : Bologna , ʻO Ferrara , Wahi , Cesena , Modena , Parma , Piacenza, Ravenna , ʻO Reggio Emilia , Rimini
Friuli Venezia Giulia : ʻO Keloria , Pordenone , Trieste , Udine
Lazio : Frosinone , Latina , Rieti , Rome , Viterbo
Liguria : Genoa , Imperia , Mea ʻala , Savona
Lombardy : Bergamo , Brescia , Como , Cremona , Lecco , Mantua , Milan , Pavia , Sondrio , Varese
ʻO Marche : Ancona , Ascoli piceno , ʻO Macerata , Kaumaha au , Urbino
Molise : Campobasso , Isernia
Piedmont : Alessandria , Asti , ʻO Biella, Cuneo , Novara , Turin , ʻO Vercelli
Puglia : Bari , Brindisi , Foggia, Lecce , Taranto
Sardinia : Cagliari , ʻĀpana , ʻO Iklesias , nuoro , ʻO Ogliastra, Olbia , Luakini , Oristano , Sasari
Sicilia : ʻAukake , ʻO Caltanissetta , Catania , Enna , Messina , Palermo , Ragusa , Syracuse , Trapani , Marsala , ʻO Mazara del vallo, pantelleria
Tuscany : Arezzo , Florence , ʻO Grosseto , Livorno , Lucca , Massa Carrara , Pisa , Pistoia , Prato , Iā Siena
ʻO Trentino Alto Adige : ʻO Bolzano , Trento
Veneto : Belluno , Padova , Rovigo , ʻO Treviso , Venice , Verona , ʻO Vicenza
Svizzera: Lugano, Canton of Ticino, bellinzone, Locarno, mendrisio, hū.
Postgresql DBA
Ua aʻo ʻo CEO Stefano Fantin i ke code kumu o ka DBMS ʻO Postgresql mai Postgresql version 8 a hiki i Postgresql 9.5, ua hoʻololi mākou i ka version 10 a ma ka version 11 Postgresql version 12 i puka mai. Pūnaewele pūnaewele pūnaewele ke hoʻopukapuka nei i ka manawa a me ke kālā i ka noiʻi a me ka hoʻomohala ma Postgresql 13.
KUHI DBA POSTGRESQL:
Lama Waihona DBA Postgresql 8.0: PITR, Tablespace, Kākoʻo Pūnaewele, Mālama
Lama Waihona DBA Postgresql 8.1: Hōʻailona papa ʻaina, nā pākēkē Bitmap, ʻelua mau lua hana, autovacuum
Lama Waihona DBA Postgresql 8.2: Warm Standby, SQL 2003, Kūkulu Kūʻē Kūʻai Kūʻai, index index Gin
Lama Waihona DBA Postgresql 8.3: Nā hōʻano hou, Asynchronous komit, XML, ʻimi piha ʻo Fulltext, ʻōpili hōʻē
Lama Waihona DBA Postgresql 8.4: Nā hana Windows, CTE, hōkeoʻikepili nā hōʻuluʻulu ʻana, ʻae ʻia no kēlā me kēia kolamu
Lama Waihona DBA Postgresql 9.0: Kūleʻa Hotby, Nā Hoʻomohoke ʻana o nā Koloa, Kāwewe Kūpono, nā Kelepona Kūwila, kahi hale kūʻai
Lama Waihona DBA Postgresql 9.1: Pūnaewele, Pūnaewele, Pūnaewele, Pūnaewele, Nā Kuhi Pūʻulu Haole, Pūnaewele Uwau ʻia, Hoʻomoka ʻo Serialisable.
Lama Waihona DBA Postgresql 9.2: Hōʻike Cascading, Index-Nā kuʻina, pg_stat_statements, Json, Ranges
Lama Waihona DBA Postgresql 9.3: Nā mea kākau moʻolelo kūwaho haole, nā ʻike maka, JSON hana a me nā mea hana, LATERAL
Lama Waihona DBA Postgresql 9.4: ʻO ka hana hou ʻana, nā kau Replication, JSONB -> GIN (Generalized Inverted Index), scalability: Logical Decoding
Lama Waihona DBA Postgresql 9.5: UPSERT, palekana pae pae, hana no BigʻIkepili: ʻO ka index BRIN, algorithm i kapa ʻia "nā kī i hoʻopōkole ʻia", CUBE, ROLLUP, a me GROUPING SET, TABLESAMPLE, Nā ʻIke ʻikepili haole (FDW)
Lama Waihona DBA Postgresql 9.6: ʻO ka hoʻonui ʻia ʻana ma o nā nīnau like, ʻo ka hoʻopaʻa ʻana ma o ka hoʻopili like ʻana a me ka 'postgres_fdw', ʻoi aku ka maikaʻi o ka huli kikokikona me nā ʻōlelo. Nīnau Parallel: Nā hiʻohiʻona kaʻina like, nā hui like, nā hōʻuluʻulu like.
Nā wahi kūʻai, VACUUM a me ka palapala ʻike: pg_visibility extension no ka nānā ʻana i nā palapala ʻike, nā ʻaoʻao ʻaoʻao Frozen i ka palapala ʻike no ka hemo ʻana i ka hakahaka ma nā ʻikepili i hoʻopaʻa mua ʻia, ka hoʻopau ʻia ʻana o ka hana a nā snapshot e kāohi ai i ka lemat meja. Ka hana ʻana a me ka nānā ʻana:
Nā ʻikepili ʻimi i hōʻike ʻia i loko o pg_stat_activity, Ka helu ʻonaʻī wale ʻana no nā māka ʻāpana, hoʻomaikaʻi i ka hoʻomaʻamaʻa ʻana no ka hana o waho. Manaʻoʻōlelo a me ka hoʻokele ʻana: Hōʻike pūnaewele hou i pg_config, pg_blocking_pids, Nā hana pg_get_ * e hoʻi ai ʻo NULL ma ka pololei
mea, pg_notification_queue_usage e nānā i ka leka hoʻomaopopo. Hoʻihoʻi: pg_basebackup i hoʻonui ʻia me nā slot replication, API hou no nā kākoʻo kino wela. ʻO nā hiʻohiʻona ʻē aʻe: Ka hōʻike ʻana i ka holomua o ka holomua, Generic WAL facility, Trigonometric functions in degere.
ʻAʻole wale kēlā mau mea e pili iā mākou e koho iā mākou.
E ʻike hou aʻe mai ka Pūnaewele Pūnaewele Pūnaewele
E kau inoa no ka loaʻa ʻana o nā ʻatikala hou loa ma ka leka uila.