K-nearest neighbor is a proximity algorithm to find data in order of distance. Typically, this data cannot be indexed in advance, as both the centroid and the data can be in constant motion. PostgreSQL provides efficient searching algorithms for finding proximity data on the fly, including unique, high-performance indexing options. For a deeper understanding of how K-nearest neighbor (KNN) works...

Handling dates, time, and time zones is a very complex matter and gets even more complicated when you implement them into databases. PostgreSQL is well equipped to handle such complexities and provides powerful, native support for handling date/timestamp data types. In order to explore the proper use of dates, timestamps, and interval data types, 2ndQuadrant hosted a live webinar, Date/Timestamp...

PostgreSQL is a hyperconverged DBMS offering functionalities that otherwise require specialized database technology. Developing a Graph Database is one such use case. To explore Graph Databases in more detail, 2ndQuadrant held a live webinar, “ Creating Graph Databases in PostgreSQL ”, which was hosted by Simon Riggs (CEO at 2ndQuadrant). In this webinar, Simon demonstrated how PostgreSQL can be...

PostgreSQL users are always interested in their system’s performance to know if any improvements need to be made or to generate the occasional health report requested by their managers. Standard monitoring tools are available to monitor the CPU, RAM, and I/O consumption, but they won’t be able to tell you if indexes are being used, if tables are bloated, if there is a lag of replication or a...

Identity Columns, initially rolled out in PostgreSQL 10, offer a standard-conforming and robust way to dynamically create auto-incrementing fields in tables. Generated Columns, computed from other columns, were first introduced in PostgreSQL 12. They enable more flexible schema design and performance benefits for your database. To cover the topic of “ Identity Columns and Generated Columns in...

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 Riggs (CEO at 2ndQuadrant) , with the aim to bring everyone up-to-speed with the...

The new PostgreSQL 12 release is just around the corner and by popular demand, the team at 2ndQuadrant hosted “ New Features in Postgres 12″ webinar. The 1 hour + long session, conducted by Peter Eisentraut (Core Team Member of the PostgreSQL Project), gave an in-depth preview of everything new in PostgreSQL 12, improvements to partitioning, generated columns, future plans for PostgreSQL 13 and a...