The elephant has been the symbol of PostgreSQL for many years now, referring to the robustness and strength as well as its reputed wisdom. Long may that association continue. Even after many years of protection, the elephant is being killed by poachers at an incredible rate of 20,000 per year, or approximately 1 elephant will […]
PostgreSQL and IoT Data Localization, Integration, and Write Scalability
/0 Comments/in Haroon's PlanetPostgreSQL, Internet of Things /by Muhammad HaroonIn 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 partitions is to achieve better performance, especially in IoT environments, where active data is usually the most recent data. New data is usually append only […]
Talk slides: Partitioning Improvements in PostgreSQL 11
/0 Comments/in Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro HerreraI spent a couple of days in São Paulo, Brazil last week, for the top-notch PGConf.Brazil 2018 experience. This year I gave a talk about improvements in the declarative partitioning area in the upcoming PostgreSQL 11 release — a huge step forward from what PostgreSQL 10 offers. We have some new features, some DDL handling […]
PostgreSQL Time-based Partitioning for IoT Data using pg_partman
/0 Comments/in Haroon's PlanetPostgreSQL, Internet of Things /by Muhammad HaroonThis blog continues the discussion from my previous post on IoT Solution‘s scalability for IoT workloads where I discussed how declarative partitioning in PostgreSQL 10 can help achieve scalability. While native declarative partitioning is a good start, the experience of creating and maintaining the same partitions I did in my last post becomes much more fun […]
Postgres Installer – A Step by Step Guide to install PostgreSQL
/1 Comment/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, Postgres Installer, PostgreSQL /by Liaqat AndrabiWebinar : Ansible & PostgreSQL [Follow Up]
/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, Webinars /by Liaqat AndrabiPostgreSQL administration, configuration, and deployment can be a tough ask while working in an agile environment with strict deadlines. The key to simplify these operational tasks for PostgreSQL is Ansible – an open source IT automation tool. To explain how these technologies work together, 2ndQuadrant hosted a Webinar on PostgreSQL deployments using Ansible. The webinar […]
Supporting the Elephant
/0 Comments/in Simon's PlanetPostgreSQL /by Simon RiggsThe elephant has been the symbol of PostgreSQL for many years now, referring to the robustness and strength as well as its reputed wisdom. Long may that association continue. Even after many years of protection, the elephant is being killed by poachers at an incredible rate of 20,000 per year, or approximately 1 elephant will […]
Scaling IoT Time Series Data with Postgres-BDR
/3 Comments/in 2ndQuadrant, Haroon's PlanetPostgreSQL, Internet of Things /by Muhammad HaroonA couple of weeks back, I wrote about how to use Windows Functions for time series IoT analytics in Postgres-BDR. This post follows up on IoT Solution‘s time series data and covers the next challenge: Scalability. ‘Internet of Things’ is the new buzzword as we move to a smarter world equipped with more advanced technologies. From transport […]
Postgres-BDR 3.0 with OmniDB
/6 Comments/in OmniDB, William's PlanetPostgreSQL /by William IvanskiIntroduction OmniDB 2.8 introduced support for Postgres-BDR 3.0, the ground-breaking multi-master replication tool for PostgreSQL databases, announced last month in PostgresConf US. Here we have 2 virtual machines with Postgres-BDR 3.0 installed and we will use OmniDB to connect to them and setup replication between the machines. Pre-requisites Postgres-BDR 3.0 requires PostgreSQL 10 or better […]
Data Modelling – It’s a lot more than just a diagram
/0 Comments/in 2ndQuadrant /by George McGeachieIf the title of this blog post rings a bell with you, perhaps you were at PG Day in Horwood House in 2014, when I stood up for 5 minutes to make the case for data modelling; a data model is much more than just a diagram. I shouldn’t be, but I am often amazed […]
Keeping our perl code clean
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanRecently I have been refining and adding utilities to look after our Perl code. You might be surprised to learn that as well as 1.3 million or so lines of C code, there are about 30,000 lines of Perl code in our sources. This a sizeable body of code, even if it’s dwarfed by our […]