2ndQuadrant Archives - Page 3 of 13 - 2ndQuadrant

Webinar: PostgreSQL is NOT your traditional SQL database [Follow Up]

October 31, 2018/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL /by Liaqat Andrabi

PostgreSQL is referred to as “The world’s most advanced open source database” – but what does PostgreSQL have that other open source relational databases don’t? 2ndQuadrant recently hosted a webinar on this very topic: PostgreSQL is NOT your traditional SQL database, presented by Gülçin Yıldırım Jelínek, Cloud Services Manager at 2ndQuadrant. The recording of […]

PostgreSQL 11: Partitioning Evolution from Postgres 9.6 to 11

October 24, 2018/0 Comments/in 2ndQuadrant, David's PlanetPostgreSQL /by David Rowley

During the PostgreSQL 11 development cycle an impressive amount of work was done to improve table partitioning. Table partitioning is a feature that has existed in PostgreSQL for quite a long time, but it really wasn’t until version 10 that it started to become a highly useful feature. We’d previously claimed that table inheritance was […]

Adding new table columns with default values in PostgreSQL 11

October 18, 2018/1 Comment/in 2ndQuadrant, Andrew's PlanetPostgreSQL /by Andrew Dunstan

In PostgreSQL version 10 or less, if you add a new column to a table without specifying a default value then no change is made to the actual values stored. Any existing row will just fill in a NULL for that column. But if you specify a default value, the entire table gets rewritten with […]

PGDay Down Under 2018

October 18, 2018/0 Comments/in 2ndQuadrant, Andrea's Planet PostgreSQL /by Andrea Cucciniello

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 Zealand, due to the fact these countries are located in the lower latitudes of the southern hemisphere. The conference is a one-day community event organized by […]

PG Phriday: Studying Stored Procedures in Postgres 11

October 12, 2018/6 Comments/in 2ndQuadrant, Shaun's PlanetPostgreSQL /by Shaun Thomas

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. Whether it’s improvements in parallelism, partitions, stored procedures, JIT functionality, or any number of elements in the release page, there’s a lot to investigate. It […]

Upgrading to PostgreSQL 11 with Logical Replication

September 6, 2018/5 Comments/in 2ndQuadrant, Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

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 between PostgreSQL major versions. Until now, PostgreSQL 10 was the only PostgreSQL release with native logical replication, so there weren’t many opportunities for upgrading in […]

Postgres Installer by 2ndQuadrant – now supports OmniDB!

September 4, 2018/0 Comments/in 2ndQuadrant, Marriya's PlanetPostgreSQL, OmniDB, Postgres Installer /by Marriya Malik

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 Windows, Linux and macOS. The latest Postgres Installer release includes support for OmniDB – an interactive and user-friendly database management tool to manage multiple databases in […]

Postgres Installer – A Step by Step Guide to install PostgreSQL

July 18, 2018/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, Postgres Installer, PostgreSQL /by Liaqat Andrabi

Here’s a step by step guide to install PostgreSQL on your machine using Postgres Installer. Postgres Installer supports three modes of installation; Graphical, Unattended and Text. We’re going to cover all three of them in this guide. To Install PostgreSQL via Graphical Mode Step 1: Download Postgres Installer here. Postgres Installer is available for PostgreSQL […]

Webinar : Ansible & PostgreSQL [Follow Up]

July 11, 2018/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, Webinars /by Liaqat Andrabi

PostgreSQL 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 […]

Scaling IoT Time Series Data with Postgres-BDR

July 3, 2018/2 Comments/in 2ndQuadrant, Haroon's PlanetPostgreSQL, Internet of Things /by Muhammad Haroon

A 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 […]