Blog: Vasilis Ventirozos

210 blogs updated: 12 min. ago
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
Tip for faster wal replay on a slave
I've been in situations where i need a slave db to replay a lot of wal files fast, and by a lot i mean tens of thousands. This could happen ...
09-06-2017 16:46:36 Vasilis Ventirozos PostgreSQL
Reusing an old master (as slave) after a switchover
Todays blogpost is old news but it's not very well known and it has to do with how to add an old master after a slave has been promoted. Fuj...
19-05-2017 16:25:57 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.