Tinoshanda senge database maneja Oracle a:
Milan, Bergamo, Brescia, Varese, Como, Cremona , Lecco, Mantova, Pavia, Sondrio, asi isu tinoshandawo,
Abruzzo : Akwira , Chieti , Pescara , Teramo
Basilicata : Matera , Potenza
kuCalabria : Catanzaro , Cosenza , Crotone , Reggio Calabria , Vibo Valentia
Campania : Avellino , Benevento , caserta , Naples , Salerno
Emilia Romagna : Bologna , Ferrara , Forlì , Cesena , Modena , Parma , nePiacenza, Ravenna , Reggio Emilia , Rimini
Friuli Venezia Giulia : Gorizia , Pordenone , Trieste , Udine
Lazio : Frosinone , Latina , Rieti , Roma , Viterbo
Liguria : kuGenoa , Imperia , Spice , yeSavona
Lombardy : Bergamo , Brescia , Como , Cremona , Lecco , Mantova , Milan , Pavia , Sondrio , Varese
Kurume : Ancone , Ascoli Piceno , Macerata , ndinoyera , Urbino
Molise : Campobasso , Isernia
Piedmont : Alessandria , Asti , Biella, Wedge , Novara , Turin , Vercelli
Puglia : Bari , Brindisi , Foggia, Lecce , Taranto
Sardinia : Cagliari , Carbonia , Iglesias , nuoro , Ogliastra, Olbia , Tembere , Oristano , Sassari
Sisiri : agrigento , Caltanissetta , Catane , Enna , Messina , Palerme , Ragusa , Syracuse , Trapani , Marsala , Mazara del vallo, pantelleria
Tuscany : Arezzo , Florence , Grosseto , Livorno , Lucca , Massa Carrara , Pisa , Pistoia , Prato , Siena
Trentino Alto Adige : Bolzano , Tre
vèneto : Belluno , Padova , Rovigo , Treviso , Venice , Verona , Vicenza
Svizzera: Lugano, Canton yeTicino, bellinzone, Locarno, mendrisio, Chiasso.
Postgresql DBA
CEO Stefano Fantin akadzidza kodhi yekodhi yeiyo DBMS Postgresql kubva mushanduro 8 yePostgresql kusvika kuPostgresql 9.5, isu takachinja kuita vhezheni yegumi uye kuti vhezheni 10 vhezheni yePostgresql 11 yaburitswa. Pawebhu webhusaiti kuri kuisa nguva nemari mukutsvaga uye kusimudzira paPostgresql 13.
REMOTE DBA POSTGRESQL:
Kure kure DBA Postgresql 8.0: PITR, Tablespace, Windows Tsigiro, Masipi
Kure kure DBA Postgresql 8.1: Tafura yekuparadzanisa, Bitmap scans, maviri-Phase commits, autovacuum
Kure kure DBA Postgresql 8.2: Yakamira Yakamira, SQL 2003, Yakasarudzika Index Kuvaka, Gin indekisi
Kure kure DBA Postgresql 8.3: Kudzokorora kupisa, Asynchronous ahadi, XML, Kutsvaga kwakazara, Yakawanikwa yekutarisa
Kure kure DBA Postgresql 8.4: Windows mashandiro, maCTE, Database collations, Per-Column mvumo
Kure kure DBA Postgresql 9.0: Kupisa Kumira, Kutenderera Kudzokorora, Column Trigger, Mamiriro Ezvinogadzirisa, hstore
Kure kure DBA Postgresql 9.1: Synchronous Replication, Wakaverengeka CTE, Kuwedzeredza, Vatorwa Idzi Vanyori, Matafura asina kubvumidzwa, seriisable Snapshot Isolate, Column collation
Kure kure DBA Postgresql 9.2: Cascading Replication, Index-Chete scans, pg_stat_statements, Json, Ranges
Kure kure DBA Postgresql 9.3: Anonyorwa Zvekune dzimwe Nyika Dataiki Vanyori, Materialised Views, JSON inoshanda uye vanoshanda, LATERAL
Kure kure DBA Postgresql 9.4: Kudzokorora zvine musoro, Kudzokorodza nzvimbo, JSONB -> GIN (Generalized Inverted Index), scalability: Logical Decoding
Kure kure DBA Postgresql 9.5: UPSERT, Row-chikamu chengetedzo, mashandiro e Big Data: BRIN index, algorithm inonzi "makiyi akapfupikiswa", CUBE, ROLLUP, uye GROUPING SET, TABLESAMPLE, Kunze Dhata Vanoputira (FDW)
Kure kure DBA Postgresql 9.6: Vertical kuyera kuburikidza yakafanana mibvunzo, Horizontal kuyera kuburikidza synchronous kudzokorodza uye 'postgres_fdw', Zvirinani zvinyorwa kutsvaga nemitsara. Mubvunzo wakafanana: Kuenzanirana kwakaenzana scans, yakafanana majoini, akaenzana aggregates.
Shanduko, VACUUM uye iyo Mepu inooneka: pg_visibility yekuwedzera yekuongorora mamepu, Frozen peji dhata mune inooneka mepu yekuputika vacuum pane yatove yakaomeswa data kare, Mushandisi-akatsanangurwa kudzima kwemazano ekudzora tafura bloat. Performance uye Monitoring:
Yakadzama yokumirira ruzivo mu pg_stat_activity, Index-chete scans yemasheni indexes, Performance kuvandudzwa kwekunze mhando mabasa. Maonero eSystem uye Kudzora: Sisitimu nyowani pg_config, pg_blocking_pids, Mabasa pg_get_ * kudzosa NOKO pane zvisiri izvo.
zvinhu, pg_notification_queue_usage yakatarisa pakuzivisa mutsara. Backups: pg_basebackup yakawedzerwa neiyo replication slots, New API yekupisa muviri backups. Zvimwewo Zvirevo: Raira kufambira mberi kushuma, Generic WAL nzvimbo, Trigonometric inoshanda mumadhigiri.
ASI VEGA VARI PEDYO NESU VATISARUDZA.
Tsvaga zvimwe kubva Online Web Agency
Nyorera kuti ugamuchire zvinyorwa zvichangoburwa neemail.