Webinars Archives - Page 2 of 4 - 2ndQuadrant

Webinar: KNN Indexing in PostgreSQL [Follow Up]

May 4, 2020/0 Comments/in Webinars /by Bilal Ibrar

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 […]

Webinar: Date/Timestamp types in PostgreSQL [Follow Up]

April 27, 2020/0 Comments/in Webinars /by Bilal Ibrar

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 […]

Webinar: Creating Graph Databases in PostgreSQL [Follow Up]

April 20, 2020/0 Comments/in Webinars /by Bilal Ibrar

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 […]

Webinar: pg_catalog Unveiled! [Follow Up]

April 13, 2020/0 Comments/in Webinars /by Bilal Ibrar

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, […]

Webinar: Identity Columns and Generated Columns in PostgreSQL [Follow Up]

April 6, 2020/0 Comments/in Webinars /by Bilal Ibrar

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 […]

Webinar: State of Full Text Search in PostgreSQL 12 [Follow Up]

March 13, 2020/0 Comments/in Webinars /by Liaqat Andrabi

Increasing robustness of Full Text Search in PostgreSQL allows applications like Search Engines and Text Editing Software to utilize native support without the need for 3rd party search tools. The release of PostgreSQL 12 added new capabilities to Full Text Search in terms of rich features, performance improvements, efficiency and more. 2ndQuadrant hosted a webinar […]

Webinar: All you need to know about CREATE STATISTICS [Follow Up]

February 27, 2020/0 Comments/in 2ndQuadrant, Webinars /by Nouman

Tomas Vondra, PostgreSQL Database Engineer at 2ndQuadrant, presented a webinar on CREATE STATISTICS command in PostgreSQL. The command was initially introduced in PostgreSQL 10 and saw further improvements in PostgreSQL 12. This command allows the database to collect multi-column statistics which helps the optimizer understand dependencies between columns, produces more accurate estimates and results in […]

Webinar: Application Schema Migration [Follow Up]

February 6, 2020/0 Comments/in Webinars /by Liaqat Andrabi

With applications evolving over time, there’s a need to enhance and evolve database schema as well. Sometimes this process involves some database tables and columns, creating new constraints and indexes, or even changing data types. In order to discuss Schema Migration in detail, 2ndQuadrant hosted the “Application Schema Migration” webinar, providing an in-depth overview of […]

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

January 17, 2020/1 Comment/in 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 […]