• How to limit rows to at most N per category – select * from depesz;

  depesz.com

  How to Limit Rows to At Most N Per Category — One of those things that sounds simple, but isn’t quite as simple in practice. There’s a lot of SQL to enjoy here(!) and it’ll be an eye opener if you haven’t worked with triggers in a while.

  • Add  

  1

Appears in lists (1)

• Issue 383 - Postgres is the 'batteries included' database

More like this (3)

• 

  Performance differences between normal and generic audit triggers

  

  cybertec-postgresql.com

  Performance Differences Between Normal and Generic Audit Triggers — Triggers are useful for tracking changes in...

  Performance Differences Between Normal and Generic Audit Triggers — Triggers are useful for tracking changes in audit situations, but there are different approaches with different performance characteristics to consider.

  • Read
  • Add  

  
• 

  PostgreSQL count(*) made fast - Cybertec

  

  cybertec-postgresql.com

  2. How To Improve The Performance of COUNT(*) — Using count(*) can cause performance problems. This article...

  2. How To Improve The Performance of COUNT(*) — Using count(*) can cause performance problems. This article explores a variety of options to make counting rows faster using approximations and other tricks.

  • Read
  • Add  

  
• 

  okbob/plpgsql_check

  

  github.com

  plpgsql_check: A PL/pgSQL Code Checker — This is quite specialized but if you’re looking to find...

  plpgsql_check: A PL/pgSQL Code Checker — This is quite specialized but if you’re looking to find any errors lurking in your PL/pgSQL functions, it could be a lifesaver. The project is quite old but has been kept up to date and runs on modern Postgres versions.

  • Add