After the success of last year’s event, the second PGDay held in Australia, we’re back this year with PGDay Down Under. The name “Down Under” refers to Australia and New...
Studying Stored Procs in Postgres 11 With Postgres 11 looming on the near horizon, it’s only appropriate to check out a recent beta and kick the tires a few times...
Postgres contains a moving event horizon, which is in effect about 2 billion transactions ahead of or behind the current transaction id. Transactions up to 2 billion ahead of or...
The video of my presentation below walks you through the major features of the native JSON data type in PostgreSQL 9.3 and beyond. https://www.youtube.com/watch?v=BtFes871CN0 This presentation covers the following topics...
The video of my presentation below walks you through ‘Indexing in PostgreSQL’ – a key component to database performance. http://www.youtube.com/watch?v=VVG8nYqIiMI This presentation covers the following topics: Various ways to access...
Database security is an increasingly critical topic for any business handling personal data. Data breach can have serious ramifications for an organization, especially if the proper security protocols are not...
It’s time. About a year ago, we published PostgreSQL 10 with support for native logical replication. One of the uses of logical replication is to allow low- or no-downtime upgrading...
Postgres Installer is a user-friendly, graphical installation and configuration tool for PostgreSQL. With just a few clicks you can install PostgreSQL – version 9.5, 9.6, 10 and 11(beta) – on...
Just in case you missed the live broadcast, the video of my presentation below covers various topics around integration of PostgreSQL with other data sources and database technologies. http://www.youtube.com/watch?v=eUPJD8ouMik This...
In my previous post we looked at various partitioning techniques in PostgreSQL for efficient IoT data management using IoT Solution. We do understand that the basic objective behind time based...
