Waxaan u shaqaynaa sida maamulaha keydka macluumaadka Oracle a:
Milan, Bergamo, Brescia, Varese, Como, jeelka , Lecco, Mantova, Pavia, Sondrio, laakiin sidoo kale waanu shaqaynaa
Abruzzo : Aquila , Chieti , Pescara , Teramo
Basilicata : Matera , xoog
Calabria : Catanzaro , Cosenza , Crotone , Reggio Calabria , Vibo Valentia
Campania : Avellino , Benevento , Caserta , Naples , Salerno
Emilia Romagna : Bologna , Ferrara , Forlì , Cesena , Modena , Parma , Piacenza, Ravenna , Reggio Emilia , Rimini
Friuli Venezia Giulia : GORIZIA , Pordenone , Trieste , Udine
Lazio : Frosinone , Latina , Rieti , Roma , Viterbo
Liguria : Genoa , Imperia , Xawaash Savona
Lombardy : Bergamo , Brescia , Como , jeelka , Lecco , Mantova , Milan , Pavia , Sondrio , Varese
Maarso : Ancona , Ascoli piceno , Macerata , waan miisaamaa , Urbino
Molise : Campobasso , Isernia
Piedmont : Alessandria , Asti , Biella, Cuneo , Novara , Turin , Vercelli
Puglia : Bari , Brindisi , Foggia, Lecce , Taranto
Sardegna : Cagliari , Kaarboonka , Kaniisadaha , Nuuro , Ogliastra, Olbia , Macbudka , Oristano , Sassari
Sicilia : Agrigento , Caltanissetta , Catania , Enna , Messina , Palermo , Ragusa , Syracuse , 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 , Venice , Verona , Vicenza
Svizzera: Lugano, Kanton ee Ticino, Bellinzona, Locarno, mendrisio, buuq.
Postgresql DBA
Maamulaha guud Stefano Fantin wuxuu bartay koodhka isha DBMS Postgresql laga bilaabo nooca 8 ee Postgresql ilaa Postgresql 9.5, waxaanu u rarnay nooca 10 iyo nooca 11 nooca Postgresql 12 waa la sii daayay. Wakaaladda shabakadda internetka waxay galinaysaa wakhti iyo lacag cilmi baadhis iyo horumarin Postgresql 13.
DBA fog POSTGRESQL:
DBA fog Postgresql 8.0: PITR, Meesha Miiska, Taageerada Daaqadaha, Goobaha kaydinta
DBA fog Postgresql 8.1: Shaxda qaybsanaan, Baadhitaannada Bitmap-ka, samaynta laba-waji, autovacuum
DBA fog Postgresql 8.2: Heerarka Diiran, SQL 2003, Tusmada Isku-dhafka ah ayaa Dhisaya, Tusmooyinka Gin
DBA fog Postgresql 8.3: Cusboonaysiinta kulul, Asynchronous balan, XML, Buuxinta qoraalka, Isbaarooyinka la qaybiyay
DBA fog Postgresql 8.4: Hawlaha Windows, CTE-yada, database ururinta, rukhsad-Column
DBA fog Postgresql 9.0: Heerarka Kulul, Ku celcelinta Socodka, Kiciyeyaasha Tiirka, Kiciyeyaasha Shuruudaha ah, hstore
DBA fog Postgresql 9.1: Ku celcelinta isku midka ah, CTE-yada la qori karo, Kordhinta, Duubabka Xogta Shisheeye, Shaxan aan la xidhin, Go'doominta Sawirka Taxanaha ah, Isku-ururinta Sadarrada
DBA fog Postgresql 9.2: Ku-noqoshada Cascading, Tilmaan-Kaliya Sawirada, pg_stat_statements, Json, Ranges
DBA fog Postgresql 9.3: Duubayaasha Xogta Shisheeye ee La Qoran karo, Aragtiyo Maadi ah, Hawlaha JSON iyo hawl-wadeennada, LATERAL
DBA fog Postgresql 9.4: Ku celcelinta macquulka ah, boosaska ku celcelinta, JSONB -> GIN (Tusmada Guud ee leexleexan), miisaan: Go'aamin macquul ah
DBA fog Postgresql 9.5: UPSERT, Amniga heerka safka, shaqeynta Macluumaad weyn: BRIN index, algorithm loo yaqaan "furayaasha la soo gaabiyey", CUBE, ROLLUP, iyo GROUPING SET, TABLESAMPLE, Duubayaasha Xogta Shisheeye (FDW)
DBA fog Postgresql 9.6: Miisaanka tooska ah iyada oo loo marayo weydiimo isbarbar socda, miisaan toosan iyada oo la adeegsanayo ku celcelin isku mid ah iyo 'postgres_fdw', Qoraal ka wanaagsan oo weedho leh. Weydiinta Isbarbar-dhigga: Sawirro is-daba-joog ah oo is-bar-bar socda, isku-daryo is-bar-bar-bar-bar socda
Wax kala iibsiga, VACUUM iyo Khariidadda Muuqda: pg_visibility kordhinta ee baadhista maabyada muuqashada, xogta bogga la qaboojiyey ee khariidadda muuqashada ee ka boodidda faakuumka xogta mar hore la barafeeyey, Isticmaaluhu-qeexay dhicitaanka sawir-qaadista si loo xakameeyo calool-xumada miiska. Waxqabadka iyo Kormeerka:
Macluumaad sugitaan oo faahfaahsan oo ku jira pg_stat_activity, Tusmada-kaliya waxay baadhayaan tusmooyinka qayb ahaan, Horumarka waxqabadka ee hawlgallada nooca dibadda ah. Aragtida Nidaamka iyo Maamulka: Aragtida nidaamka cusub pg_config, pg_blocking_pids, Functions pg_get_ * si loogu soo celiyo NULL mid aan sax ahayn
walxaha, pg_notification_queue_usage si loo eego safka ogeysiinta. Backups: pg_basebackup oo lagu kordhiyey boosaska ku celcelinta, API cusub ee kaydinta jidheed ee kulul. Astaamaha kale: Warbixinta horumarka taliska, xarunta WAL ee guud, hawlaha trigonometric ee darajooyinka.
KELIYA INTAAN INAGA DHAWRAN INA AY INOO DOORATO.
Wixii ka soo kordha kala soco Wakaalada Shabakadda ee Online
Isdiiwaangeli si aad u hesho qoraaladii ugu dambeeyay email ahaan