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 […]
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 […]
On Rocks and Sand
/10 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasWhen working with database capacity planning, there are a lot of variables to consider, and Postgres is no different in this regard. One of the elements which requires management is storage. However, there’s an aspect of storage that escapes inspection almost without exception, and it’s hiding in the shadows between the columns themselves. Alignment Basics […]
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 […]
Webinar : Database Security in PostgreSQL [Follow Up]
/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat AndrabiDatabase security is an increasingly critical topic for any business handling personal data. Data breach can have serious ramifications for an organization, especially if the proper security protocols are not in place. There are many ways to harden your database. As an example PostgreSQL addresses security using firewalls, encryption and authentication levels among other ways. […]
PostgreSQL for IoT Data Retention and Archiving
/1 Comment/in Haroon's PlanetPostgreSQL, Internet of Things /by Muhammad HaroonWe do understand that IoT revolution is resulting in enormous amounts of data. With brisk data growth where data is mostly time series append-only, relational databases and DBAs have a rather tough task to store, maintain, archive and in some cases get rid of the old data in an efficient manner. In my previous posts, […]
Upgrading to PostgreSQL 11 with Logical Replication
/8 Comments/in 2ndQuadrant, Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter EisentrautIt’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!
/0 Comments/in 2ndQuadrant, Marriya's PlanetPostgreSQL, OmniDB, Postgres Installer /by Marriya MalikPostgres 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 […]
[Video] Data Integration with PostgreSQL
/4 Comments/in PostgreSQL, Shaun's PlanetPostgreSQL /by Shaun ThomasJust in case you missed the live broadcast, the video of my presentation below covers various topics around integration of PostgreSQL with other data sources and database technologies. This presentation covers the following topics: What is a Foreign Data Wrapper? How to query MySQL, a Flat file, a Python script, a REST interface and a […]