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

  depesz.com

  How to Limit Rows to At Most N Per Category (Take Two) — Several issues ago we linked to a handy tutorial demonstrating how to limit the rows returned by a query to a certain number per some second condition. It had a problem related to concurrency, however, so Hubert has a second go at it here.

  • Add  

  1

Appears in lists (1)

• Issue 388 - How hash indexes can actually be good

More like this (3)

• 

  Trigger Warning. Setting Up DB Auditing with SQL Triggers

  

  arctype.com

  • Read
  • Add  

  
• 

  Using Postgres Row-Level Security in Python and Django

  

  pganalyze.com

  Using Postgres Row-Level Security in Python and Django This article shows how to create and implement...

  Using Postgres Row-Level Security in Python and Django This article shows how to create and implement a row level security policy with Django middleware and Django signals, giving database administrators a way to limit the rows a user can access, adding an extra layer of data protection. JOSH ALETTO • Shared by Manuel Weiss

  • Read
  • Add  

  1
• 

  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