Queries

Foreign Data Wrappers

Using foreign data wrappers to combine metrics across a distributed database cluster

Valerie Parham-Thompson
Ansible, Automation, Distributed-Systems, Postgres, Queries, Rdbms, Yugabytedb
I was recently setting up a demo to show off query logging features. Two common extensions, pg_stat_statements and pg_stat_monitor, store data locally. In the case of a distributed database, it is helpful to combine the query runtimes on all nodes.

String Search

Link to YFTT fuzzy matching for string searches

Valerie Parham-Thompson
Distributed-Systems, Linguistics, Queries, Yugabytedb
Quick post to share my presentation last week at the YugabyteDB Friday Tech Talk. It was on fuzzy matching, and more generally string searches. Got to nerd out on two of my favorite topics: words (broadly, linguistics and specifically, names) and databases. Check it out!