3 ms·

> why? while true: select count(*) from huge_table thats why.

• somurzakov 6y ago
  1.if that table is a materialized view with columnstore index then you can run it as many times as you want. 2. always hide postgREST behind API gateway/load balancer/waf/ids+ips/rate limiter and you will be more secure from stuff lile this
• ruslan_talpa 6y ago
  You can setup a view (accessed by postgrest) that returns an error when there are no (correct) filters in the query so that takes care of select *... problem (also you can have the same logic in the proxy (nginx) layer