A ṣiṣẹ bi administrator database Oracle a:
Milan, Bergamo, Brescia, Varese, Como, Cremona , Leko, Mantua, Pavia, Sondrio, sugbon a tun ṣiṣẹ,
Abruzzo : Akuila , Chieti , Pescara , Teramo
Basilicata : Matera , Potenza
Calabria : Catanzaro , Cosenza , Crotone , Reggio Calabria , Vibo Valentia
Campania : Avellino , Benevento , Caserta , Naples , Salerno
Emilia Romagna : Bologna , Ferrara , Forlì , Cesena , Modena , Parma , Piacenza, Ravenna , Regigio Emilia , Rimini
Friuli Venezia Giulia : Gorizia , Pordenone , Trieste , Udine
Lazio : Frosinone , Latina , Rieti , Rome , Viterbo
Liguria : Genoa , Imperia , Turari, Savona
Lombardy : Bergamo , Brescia , Como , Cremona , Leko , Mantua , Milan , Pavia , Sondrio , Varese
Rìn : Ancona , Ascoli piceno , Macerata , Mo wọn , Urbino
Molise : Campobasso , Isernia
Piedmont : Alessandria , Asti , ọpá asopọ, Wedge , Novara , Turin , Vercelli
Puglia : Bari , Brindisi , Foggia, Lecce , Taranto
Sardinia : Cagliari , Erogba , Ijo , nuoro , Ogliastra, Olbia , Tẹmpili , Oristano , Sassari
Sicilia : agrigento , Caltanissetta , Catania , enna , Messina , palermo , Ragusa , Siracusa , Trapani , Marsala , Mazara del vallo, Pantelleria
Tuscany : Arezzo , Florence , Grosseto , Livorno , Lucca , Massa Carrara , Pisa , Pistoia , Prato , Siena
Trentino Alto Adige : Bolzano , Trento
Veneto : Belluno , Padua , Rovigo , Treviso , Venezia , Verona , Vicenza
Svizzera: Lugano, Canton ti Ticino, Bellinzona, Locarno, mendrisio, Chiasso.
Postgresql DBA
CEO Stefano Fantin iwadi awọn orisun koodu ti awọn DBMS Postgresql lati ẹya 8 ti Postgresql titi di Postgresql 9.5, a ti wa si ẹya 10 ati si ẹya 11 ẹya ti Postgresql 12 ti tu silẹ. Ile ibẹwẹ wẹẹbu lori ayelujara n ṣe idoko-owo akoko ati owo ni iwadii ati idagbasoke lori Postgresql 13.
DBA REMOTE POSTGRESQL:
DBA latọna jijin Postgresql 8.0: PITR, Tabili, Atilẹyin Windows, Awọn aaye ipamọ
DBA latọna jijin Postgresql 8.1: Pipin tabili, Awọn ọlọjẹ Bitmap, Awọn iṣẹ-ọna meji, adaṣe adaṣe
DBA latọna jijin Postgresql 8.2: Imurasilẹ gbona, SQL 2003, Atọka Itọkasi nigbakan, Awọn atọka Gin
DBA latọna jijin Postgresql 8.3: Awọn imudojuiwọn gbona, Asynchronous ṣẹ, XML, Wiwa ni kikun ọrọ, Pinpin checkpoints
DBA latọna jijin Postgresql 8.4: Awọn iṣẹ Windows, CTEs, database collations, Per-Column aiye
DBA latọna jijin Postgresql 9.0: Imurasilẹ Gbona, Atunse ṣiṣanwọle, Awọn okunfa ọwọn, Awọn okunfa ipo, hstore
DBA latọna jijin Postgresql 9.1: Amuṣiṣẹpọ, Awọn CTE ti a Kọ, Ifaagun, Awọn iwe-ipamọ data Ajeji, Awọn tabili ti a ko wọle, Ipinya fọtoyiya Serialisable, Awọn akojọpọ iwe
DBA latọna jijin Postgresql 9.2: Isọdọtun Cascading, Atọka-nikan awọn ọlọjẹ, pg_stat_statements, Json, Awọn sakani
DBA latọna jijin Postgresql 9.3: Writable Foreign Data wrappers, Materialized Views, JSON iṣẹ ati awọn oniṣẹ, LATERAL
DBA latọna jijin Postgresql 9.4: Iṣatunṣe ọgbọn, Awọn iho atunwi, JSONB -> GIN (Atọka Iyipada Agbopọ), iwọn iwọn: Iyipada adaṣe
DBA latọna jijin Postgresql 9.5: UPSERT, Aabo ipele-ila, iṣẹ ṣiṣe fun Big Data: Atọka BRIN, algorithm ti a npe ni "awọn bọtini abbreviated", CUBE, ROLLUP, ati GROUPING SET, TABLESAMPLE, Awọn iwe-ipamọ Data Ajeji (FDW)
DBA latọna jijin Postgresql 9.6: Wiwọn inaro nipasẹ awọn ibeere ti o jọra, iwọn ilawọn nipasẹ atunwi amuṣiṣẹpọ ati 'postgres_fdw', Wiwa ọrọ to dara julọ pẹlu awọn gbolohun ọrọ. Ibeere ti o jọra: Awọn iwoye itọsẹ ti o jọra, awọn akojọpọ ti o jọra, awọn akojọpọ ti o jọra.
Awọn iṣowo, VACUUM ati Maapu Hihan: pg_visibility itẹsiwaju fun ṣiṣe ayẹwo awọn maapu hihan, Awọn oju-iwe ti o tutu ninu maapu hihan fun ṣifo igbale lori data ti a ti tutunini tẹlẹ, Ipari asọye olumulo ti snapshots lati ṣakoso bloat tabili. Iṣe ati Abojuto:
Alaye idaduro ni kikun ni pg_stat_activity, Atọka-nikan ṣe ayẹwo fun awọn atọka apakan, awọn ilọsiwaju iṣẹ fun awọn iṣẹ too ita. Awọn iwo eto ati iṣakoso: wiwo eto titun pg_config, pg_blocking_pids, Awọn iṣẹ pg_get_ * lati da NULL pada ni aitọ
awọn nkan, pg_notification_queue_usage lati wo isinyi iwifunni. Awọn afẹyinti: pg_basebackup ti o gbooro pẹlu awọn iho ẹda, API Tuntun fun awọn afẹyinti ti ara gbona. Awọn ẹya miiran: Ijabọ ilọsiwaju aṣẹ, Ohun elo WAL Generic, Awọn iṣẹ Trigonometric ni awọn iwọn.
KII ṢE NI AWỌN TI O ṢE SI WA LATI YAN WA.
Wa diẹ sii lati Ile-iṣẹ Wẹẹbu Ayelujara
Alabapin lati gba awọn nkan tuntun nipasẹ imeeli.