Blog: Vasilis Ventirozos

213 blogs updated: 22 min. ago
Zero downtime upgrade PostgreSQL 10 to 11.
PostgreSQL 11 has been officially released and it's packed with exciting changes.Native declarative partitioning is more robust, parallelism...
12-11-2018 23:56:21 Vasilis Ventirozos PostgreSQL
Logical Replication in aws RDS
Recently Amazon annnounced that postgres 10 supports logical replication syntax and that it can work as either a publisher or a subscriber. ...
25-09-2018 16:29:39 Vasilis Ventirozos PostgreSQL
Implementing a "distributed" reporting server using some of postgres10 features.
Today i will try to show how strong Postgres 10 is by combining different features in order to create a "distributed" reporting server. The ...
01-03-2018 17:04:03 Vasilis Ventirozos PostgreSQL
Postgres10 in RDS, first impressions
As a firm believer of Postgres, and someone who runs Postgres 10 in production and runs RDS in production, I've been waiting for Postgres 10...
27-02-2018 16:59:46 Vasilis Ventirozos PostgreSQL
AWS Aurora Postgres, not a great first impression
Recently we had a customer facing some memory issues with an Aurora PostgreSQL. What was happening is that while loading data or creating Gi...
10-01-2018 20:48:34 Vasilis Ventirozos PostgreSQL
Psql directly from Atom text editor.
Im not a big fun of postgres clients like pgadmin, not sure why, but i always favoured psql over everything. A friend of mine wrote an atom ...
08-12-2017 17:39:48 Vasilis Ventirozos PostgreSQL
Monitoring statements in pg10
Recently we migrated our first client to postgres 10.1, the database used to run on 9.2. Everything went smooth with a total downtime of 12 ...
27-11-2017 20:05:12 Vasilis Ventirozos PostgreSQL
PostgreSQL on ZFS
What is ZFS. (a paste from wikipedia) ZFS is a combined file system and logical volume manager designed by Sun Microsystems. The features of...
30-08-2017 19:37:32 Vasilis Ventirozos PostgreSQL
PostgreSQL on ZFS with BPF tracing on top.
At OmniTI we love solaris, my personal favourite features are ZFS and DTrace. Unfortunately not many run postgres on solaris so i have decid...
16-06-2017 14:55:29 Vasilis Ventirozos PostgreSQL
An unusual upgrade
I have mentioned in previous posts that in my 4 years with OmniTI, we've tackled a lot of migrations. Most of them are usually the "typical"...
10-06-2017 14:02:47 Vasilis Ventirozos PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.