PostgreSQL Archives - Page 5 of 15 - 2ndQuadrant

JOIN LATERAL

March 1, 2019/2 Comments/in Elein’s PlanetPostgreSQL, PostgreSQL /by Elein

LATERAL The primary feature of LATERAL JOIN is to enable access elements of a main query in a subquery which can be very powerful. Several common uses of LATERAL are to: denormalize arrays into parent child tables aggregation across several tables row or action generation. Note, however, that the subquery will execute for each main […]

Webinar: Banking on Postgres – Financial Application Considerations [Follow up]

January 30, 2019/0 Comments/in Liaqat's PlanetPostgreSQL, PostgreSQL, Webinars /by Liaqat Andrabi

The demand for PostgreSQL within the financial industry has been rapidly increasing in the recent years; mainly due to reduction in licensing costs, better choice of open source tools, and the robust enterprise features that PostgreSQL provides. 2ndQuadrant hosted the “Banking on Postgres” webinar to discuss attributes of financial databases based on Postgres, configuration processes, […]

PostgreSQL 9.3 EOL – Why is it Important to Upgrade?

January 3, 2019/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, PostgreSQL /by Liaqat Andrabi

After the final release of patch 9.3.25 on November 8th 2018, PostgreSQL 9.3 is no longer supported. Therefore it’s time for all users of PG 9.3 to upgrade their databases to a newer supported version. The benefits of having a supported version are many and that’s what Craig Ringer talks about in the Q&A session […]

[Video] Ansible and PostgreSQL

December 12, 2018/0 Comments/in PostgreSQL, Tom's PlanetPostgreSQL /by Tom Kincaid

I don’t often get to speak on technical topics, but the video of my presentation below covers various concepts around “Ansible and PostgreSQL” – something I am very enthusiastic about. This presentation covers the following topics: Overview of Ansible and PostgreSQL Best strategies for mixed cloud and on-premises deployments How to deploy AlwaysOn PostgreSQL clusters […]

Managing Freezing in PostgreSQL

October 10, 2018/4 Comments/in Andrew's PlanetPostgreSQL, PostgreSQL /by Andrew Dunstan

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 more than 2 billion behind the current transaction id are considered to be in the future, and will thus be invisible to current transactions. Postgres […]

[Video] Introduction to JSON data types in PostgreSQL

October 7, 2018/0 Comments/in Andrew's PlanetPostgreSQL, PostgreSQL /by Andrew Dunstan

The video of my presentation below walks you through the major features of the native JSON data type in PostgreSQL 9.3 and beyond. This presentation covers the following topics: What is JSON? How is it available in PostgreSQL? What’s the difference between JSON and JSONB? Accessing JSON values Creating JSON from table data Creating table […]

Webinar : New Features in PostgreSQL 11 [Follow Up]

October 3, 2018/0 Comments/in Liaqat's PlanetPostgreSQL, PostgreSQL /by Liaqat Andrabi

PostgreSQL 11, the next major release of the world’s most advanced open source database, is just around the corner. The new release of PostgreSQL will include enhancements in partitioning, parallelism, SQL stored procedures and much more. To give PostgreSQL enthusiasts a deeper look into the upcoming release, 2ndQuadrant hosted a Webinar discussing the new features […]

PostgreSQL 11: Patch Reviewers for Partitioning Patches

September 28, 2018/0 Comments/in Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro Herrera

We seldom credit patch reviewers. I decided to pay a little homage to those silent heroes for a few of them: here’s the list of people who were credited as having reviewed the patches mentioned in my previous article for PostgreSQL 11. The number in front is the number of times they were credited as reviewers. […]

[Video] Power of Indexing in PostgreSQL

September 25, 2018/0 Comments/in Pavan's PlanetPostgreSQL, PostgreSQL /by Pavan Deolasee

The video of my presentation below walks you through ‘Indexing in PostgreSQL’ – a key component to database performance. This presentation covers the following topics: Various ways to access data in PostgreSQL Different types of indexes supported by PostgreSQL Internals of BTree and BRIN indexes Overview of GIN and GiST indexes How to find missing indexes […]

Partitioning Improvements in PostgreSQL 11

September 19, 2018/4 Comments/in Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro Herrera

A partitioning system in PostgreSQL was first added in PostgreSQL 8.1 by 2ndQuadrant founder Simon Riggs. It was based on relation inheritance and used a novel technique to exclude tables from being scanned by a query, called “constraint exclusion”. While it was a huge step forward at the time, it is nowadays seen as cumbersome […]

2ndQuadrant is now part of EDB