Blog: Vasilis Ventirozos

224 blogs updated: 26 min. ago
Managing xid wraparound without looking like a (mail) chimp
My colleague Payal came across an outage that happened to mailchimp's mandrill app yesterday, link can be found HERE. Since this was Postgre...
06-02-2019 22:08:43 Vasilis Ventirozos PostgreSQL
PostgreSQL 12 : Where in copy from
5 days ago a commit made it to 12devel that implements WHERE clause in COPY FROM. Today we're gonna see how it works and see how someone cou...
25-01-2019 11:53:33 Vasilis Ventirozos PostgreSQL
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

© 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.