postgres Archives - 2ndQuadrant

Posts

Webinar: BDR – Latest Features & Updates [Follow Up]

January 17, 2020/0 Comments/in Bilal's PlanetPostgreSQL, Webinars /by Bilal Ibrar

BDR is a rapidly evolving project — and has been generating great interest from the Postgres community. In order to give further insights into BDR, how it works and where to best apply it, 2ndQuadrant organized a live webinar on 15th January 2020. The BDR – Latest Features and Updates webinar was hosted by Simon […]

Webinar: You forgot to put the WHERE in DELETE? [Follow Up]

December 12, 2019/0 Comments/in Nouman's PlanetPostgreSQL, Webinars /by Nouman

Human oversight is one of the many reasons for compromising a database. Disasters happen, but having a solid backup and disaster recovery plan in place can help your business mitigate such risks. Martín Marqués, Head of Support Operations at 2ndQuadrant, hosted a webinar on backup and disaster recovery options in PostgreSQL. The webinar: “You forgot […]

PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes

November 5, 2019/3 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk Roybal

K-nearest neighbor answers the question of “What is the closest match?”. PostgreSQL 12 can answer this question, and use indexes while doing it.

Developing on many versions of PostgreSQL at once

August 19, 2019/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

In a developer’s ideal world there’s only one stable and one development version of the product. Everyone updates immediately to the next stable version and nobody cares about anything older. As far as I can tell this has never actually happened, ever, in the history of anything. Working on many versions PostgreSQL is a mature […]

Using Docker Hub PostgreSQL images

May 17, 2019/1 Comment/in Craig's PlanetPostgreSQL /by craig.ringer

Docker Hub carries Docker images for PostgreSQL, based on Debian Stretch or Alpine Linux. These are not official PostgreSQL Development Group (PGDG) images from postgresql.org, they’re maintained in the Docker Library on Github. But as Docker adoption grows these are going to become more and more people’s first exposure to PostgreSQL. I tried these images […]

Geo-redundancy of PostgreSQL database backups with Barman

February 19, 2019/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

Barman 2.6 introduces support for geo-redundancy, meaning that Barman can now copy from another Barman instance, not just a PostgreSQL database.

Sequential UUID Generators

November 27, 2018/15 Comments/in 2ndQuadrant, Tomas' PlanetPostgreSQL /by Tomas Vondra

UUIDs are a popular identifier data type – they are unpredictable, and/or globally unique (or at least very unlikely to collide) and quite easy to generate. Traditional primary keys based on sequences won’t give you any of that, which makes them unsuitable for public identifiers, and UUIDs solve that pretty naturally. But there are disadvantages […]

OmniDB debugger for PostgreSQL 11

November 6, 2018/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski

PostgreSQL 11 was released recently, with exciting new features. One of them is the ability to write SQL procedures that can perform full transaction management, enabling developers to create more advanced server-side applications. SQL procedures can be created using the CREATE PROCEDURE command and executed using the CALL command. Since OmniDB 2.3.0 it is possible […]

Prague PostgreSQL Meetup

March 22, 2018/0 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, International News, PostgreSQL, User Group /by Gulcin Yildirim

Last month, I was at 2ndQuadrant booth at P2D2, an annual conference organized in Prague by local user group called CSPUG (Czech and Slovak PostgreSQL User Group). The conference was certainly a huge success and more than 200 people showed up! Meeting a lot of PostgreSQL enthusiasts in town, I wondered why there are no regular meetups […]

PostgreSQL Meltdown Benchmarks

March 4, 2018/0 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

Two serious security vulnerabilities (code named Meltdown and Spectre) were revealed a couple of weeks ago. Initial tests suggested the performance impact of mitigations (added in the kernel) might be up to ~30% for some workloads, depending on the syscall rate. Those early estimates had to be done quickly, and so were based on limited […]