How to use indexes to optimize PostgreSQL queries

• postgresDBSamples

  1 418 4.5 PLpgSQL

  Sample databases for postgres

For this example we'll use a sample database with USDA food information. The .sql file to create and populate the database can be downloaded from here. We'll also be using SeeQR, an open source PostgreSQL analytics tool that I've recently been contributing to. If you'd like to follow along the examples you should have:

• SeeQR

  4 578 9.6 TypeScript

  A database analytic tool that allows developers to compare the efficiency of different schemas and queries on a granular level to make better informed architectural decisions regarding SQL databases at various scales.

  

If you'd like to know more about SeeQR and contribute to it's development, visit it's repository in github. If you'd like more information about Indexes and the inner workings of PostgreSQL the https://www.postgresql.org/docs/current/ is a great place to start.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project