Peb ua haujlwm li cov neeg tswj ntaub ntawv Oracle a:
Milan, Bergamo, Brescia, Varese, Como, Cremona , Lawb, Mantova, Pavia, Sondrio, tab sis peb kuj ua haujlwm,
Abruzzo : Aquila , kev , 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 , Reggio Emilia , Rimini
Friuli Venezia Giulia : Liab twm hawj , Pordenone , Trieste , Udine
Lazio : Frosinone , Latin , Rieti , Rome , Viterbo
Liguria : Genoa , Imperia , Txuj lom , Savona
Lombardy : Bergamo , Brescia , Como , Cremona , Lawb , Mantova , Milan , Pavia , Sondrio , Varese
Lub peb hlis ntuj : Ancona , Ascoli piceno , Macerata , kuv hnyav , Urbino
Molise : Campobasso , Isernia
Piedmont : Alessandria , Asti , Biella, Cuneo , Novara , Turin , Muab tso rau hauv
Puglia : Bari , Brindisi , Foggia, Lecce , Taranto
Sardinia : Cagliari , Kev Nia , Iglesias , nuoro , Ogliastra, Olbia , Cov tuam tsev , Oristano , Sassari
Sicily : kev ua liaj ua teb , Caltanissetta , Catania , nce , Messina , Palermo , Dosaj , Syracuse , Trapani , Marsala , Mazara del vallo, pantelleria
Toscana : Arezzo , Florence , Grosseto , Livorno , Lucca , Mas Carrara , Pisa , Pistoia , Prato , Siena
Trentino Alto Adige: XNUMX Lab tus kiv cua tos koj rau Webtalk! : Bolzano , Trento
Veneto : Belluno , Padova , I rov , Treviso , Venice , Verona , Vicenza
Svizzera: Lugano, Canton ntawm Ticino, ua bellinzone, Locarno, mendrisio, suab nrov.
DBA Postgresql
CEO Stefano Fantin tau kawm txog qhov chaws ntawm lub DBMS Postgresql los ntawm Postgresql version 8 mus txog Postgresql 9.5, peb hloov mus rau version 10 thiab hauv version 11, Postgresql version 12 tuaj tawm. Lub vev xaib online chaw haujlwm yog nqis peev sijhawm thiab nyiaj txiag hauv kev tshawb fawb thiab kev loj hlob ntawm Postgresql 13.
REMOTE DBA POSTGRESQL:
Tej thaj chaw deb DBA Postgresql 8.0: PITR, Tablespace, Windows Support, Savepoints
Tej thaj chaw deb DBA Postgresql 8.1: Cov lus muab faib, Bitmap scans, Ob-theem commits, autovacuum
Tej thaj chaw deb DBA Postgresql 8.2: Sov Standby, SQL 2003, Concurrent Index Tsim, Gin indexes
Tej thaj chaw deb DBA Postgresql 8.3: Kev hloov tshiab kub, Asynchronous cog lus, XML, Kev tshawb nrhiav puv ntawv, faib cov chaw kuaj xyuas
Tej thaj chaw deb DBA Postgresql 8.4: Windows ua haujlwm, CTEs, database collations, Per-Kom kev tso cai
Tej thaj chaw deb DBA Postgresql 9.0: Hot Standby, Streaming Rov Sib Yuav, Kem Tawg, Conditional Triggers, hstore
Tej thaj chaw deb DBA Postgresql 9.1: Synchronous Replication, Writable CTEs, Extension, Foreign Data Wrappers, Unlogged tables, Serializable Snapshot Isolation, Kem collations
Tej thaj chaw deb DBA Postgresql 9.2: Cascading Replication, Index-Tsuas scans, pg_stat_statements, Json, Ranges
Tej thaj chaw deb DBA Postgresql 9.3: Sau Cov Ntaub Ntawv Txawv Tebchaws Txawv Tebchaws, Cov Khoom Siv Pom Zoo, JSON cov haujlwm thiab cov neeg ua haujlwm, LATERAL
Tej thaj chaw deb DBA Postgresql 9.4: Logical replication, Replication slots, JSONB -> GIN (Generalized Inverted Index), scalability: Logical Decoding
Tej thaj chaw deb DBA Postgresql 9.5: UPSERT, Kab-theem kev ruaj ntseg, ua haujlwm rau Cov ntaub ntawv loj: BRIN index, algorithm hu ua "keys abbreviated", CUBE, ROLLUP, thiab GROUPING SET, TABLESAMPLE, Foreign Data Wrappers (FDW)
Tej thaj chaw deb DBA Postgresql 9.6: Vertical scaling via parallel queries, Kab rov tav scaling ntawm synchronous replication thiab 'postgres_fdw', Zoo dua cov ntawv tshawb nrog cov kab lus. Parallel Query: Parallel sequential scans, parallel joins, parallel aggregates.
Kev ua lag luam, VACUUM thiab Daim Ntawv Qhia Pom Pom Zoo: pg_visibility txuas ntxiv rau kev tshuaj xyuas cov ntawv qhia pom pom, Cov ntaub ntawv khov nplooj hauv daim ntawv qhia pom pom rau kev hla lub tshuab nqus tsev ntawm cov ntaub ntawv uas twb tau khov lawm, Cov neeg siv tau txiav txim siab tas sij hawm ntawm snapshots los tswj lub rooj bloat. Kev Ua Haujlwm thiab Kev Saib Xyuas:
Cov ncauj lus kom ntxaws tos hauv pg_stat_activity, Index-tsuas scans rau ib nrab indexes, Kev ua tau zoo txhim kho rau kev ua haujlwm sab nraud. System Views and Administration : New system view pg_config, pg_blocking_pids, Functions pg_get_* kom rov qab NULL ntawm invalid
cov khoom, pg_notification_queue_usage saib ntawm ceeb toom queue. Cov thaub qab: pg_basebackup txuas ntxiv nrog cov qhov sib txuas, API Tshiab rau cov thaub qab lub cev kub. Lwm Cov Nta: Kev hais qhia kev nce qib, Generic WAL chaw, Trigonometric ua haujlwm hauv qib.
TSUAS XA RAU COV NEEG XAIV RAU PEB.
Xav paub ntau ntxiv los ntawm Online Web Agency
Sau npe yuav tau txais cov lus tseeb los ntawm email.