Remote DBA Postgresql

Remote DBA Postgresql

Il Ceo Stefano Fantin ha studiato il codice sorgente del DBMS Postgresql dalla versione 8 di Postgresql fino a Postgresql 9.5, è uscita la versione di Postgresql 9.6 .

REMOTE DBA POSTGRESQL:

Remote DBA Postgresql 8.0 : PITR, Tablespace, Windows Support, Savepoints
Remote DBA Postgresql 8.1 : Table partioning, Bitmap scans, Two-Phase commits, autovacuum
Remote DBA Postgresql 8.2 : Warm Standby, SQL 2003, Concurrent Index Builds, Gin indexes
Remote DBA Postgresql 8.3 : Hot updates, Asynchronous commit, XML, Fulltext search, Distribuited checkpoints
Remote DBA Postgresql 8.4 : Windows functions, CTEs, Database collations, Per-Column permission
Remote DBA Postgresql 9.0 : Hot Standby, Streaming Replication, Column Triggers, Conditional Triggers, hstore
Remote DBA Postgresql 9.1 : Synchronous Replication, Writable CTEs, Extension, Foreign Data Wrappers, Unlogged tables, Serialisable Snapshot Isolation, Column collations
Remote DBA Postgresql 9.2 : Cascading Replication, Index-Only scans, pg_stat_statements, Json, Ranges
Remote DBA Postgresql 9.3 : Writable Foreign Data Wrappers, Materialised Views, JSON functions and operators, LATERAL
Remote DBA Postgresql 9.4 : Logical replication, Replication slots, JSONB –> GIN (Generalized Inverted Index), scalability : Logical Decoding
Remote DBA Postgresql 9.5 : UPSERT, Row-level security, functionality for Big Data: BRIN index, algorithm called “keys abbreviated”,CUBE, ROLLUP, and GROUPING SET, TABLESAMPLE, Foreign Data Wrappers (FDW)Remote DBA Remote DBA Postgresql 9.6 : Scalabilità verticale tramite query parallele, Scalabilità orizzontale tramite replica sincrona e ‘postgres_fdw’, Miglior ricerca testuale con le frasi. Parallel Query : Parallel sequential scans, parallel joins, parallel aggregates. Transactions, VACUUM and the Visibility Map : pg_visibility extension for examining visibility maps, Frozen page data in visibility map for skipping vacuum on already-frozen data, User-defined expiration of snapshots to control table bloat. Performance and Monitoring :
Detailed wait information in pg_stat_activity, Index-only scans for partial indexes, Performance improvements for external sort operations. System Views and Administration : New system view pg_config, pg_blocking_pids, Functions pg_get_* to return NULL on invalid
objects, pg_notification_queue_usage to look at notify queue. Backups : pg_basebackup extended with replication slots, New API for hot physical backups. Other Features: Command progress reporting, Generic WAL facility, Trigonometric functions in degrees.

Remote DBA Experts.

Stefano Fantin è Remote DBA Experts perchè dedica:

  • tempo
  • denaro
  • competenze

per Remote DBA Experts.

 

Database consultant

I nostri clienti non cercano altre aziende perchè è difficile che commettiamo degli errori, sopratutto in ambito database.

Al contrario sono i clienti delle aziende nostre concorrenti che ci cercano e il motivo è perchè sono stati commessi degli errori.

Ci proponiamo con database consultant perchè crediamo nella trasformazione di:

  • Dato
    • Informazione
      • Conoscenza
        • Classificazione forte del pensiero elettronico

 

Vuoi avere maggiori informazioni sul nostro lavoro di remote DBA : clicca qui