Blog: Vasilis Ventirozos

210 blogs updated: 67 min. ago
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
PostgreSQL statistics as data
Postgres provides a lot of information when it comes to statistics. Only problem is that all the statistics are frozen in time the moment yo...
09-05-2017 18:20:58 Vasilis Ventirozos PostgreSQL
PostgreSQL upgrades - Methodology
Yesterday, i came across a conversation in postgres slack channel, someone was interested in upgrading his database and i realised that ther...
25-01-2017 18:59:25 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.