Pg_hint_plan: Force PostgreSQL to execute query plans how you want

• pg_hint_plan

  12 658 7.8 C

  Extension adding support for optimizer hints in PostgreSQL

  

Okay so it isn't entirely clear to me, can the pg_hint_plan extension (linked in the OP) do the simple thing where we specify, for each table, which index to use?

I can't find it here

https://github.com/ossc-db/pg_hint_plan/blob/master/docs/hin...

Because, the mssql WITH(INDEX()) is simple and intuitive. This hint table stuff seems complicated, and it's unclear to me if they can do the simple thing

• 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.

  

• pev2

  40 2,407 7.9 TypeScript

  Postgres Explain Visualizer 2

  

The PEV2 is open source and give you a good visualization. I never used this pgmustard to compare.

https://explain.dalibo.com/

• pg_plugins

  1 314 6.2 C

  Gathering of template plugins for PostgreSQL: background workers, logical replication things, etc.

There are many Postgres internals that people are usually not aware of, with more than one way to develop your module. I have a repo that’s a set of plugin templates here, that should be handy for your studies: https://github.com/michaelpq/pg_plugins

Suggest a related project