Webinar: Banking on Postgres – Financial Application Considerations [Follow up]
/0 Comments/in Liaqat's PlanetPostgreSQL, PostgreSQL, Webinars /by Liaqat AndrabiThe 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?
/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, PostgreSQL /by Liaqat AndrabiAfter 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
/0 Comments/in PostgreSQL, Tom's PlanetPostgreSQL /by Tom KincaidI 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
/6 Comments/in Andrew's PlanetPostgreSQL, PostgreSQL /by Andrew DunstanPostgres 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
/0 Comments/in Andrew's PlanetPostgreSQL, PostgreSQL /by Andrew DunstanThe 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]
/0 Comments/in Liaqat's PlanetPostgreSQL, PostgreSQL /by Liaqat AndrabiPostgreSQL 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
/0 Comments/in Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro HerreraWe 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
/0 Comments/in Pavan's PlanetPostgreSQL, PostgreSQL /by Pavan DeolaseeThe 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
/6 Comments/in Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro HerreraA 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 […]