Kaminari is slow with COUNT(*) on a huge table in Postgres
15357
How do I speed up counting rows in a PostgreSQL table?
43308
What is the difference between select count(*) and select count(any_non_null_column)?
47917
Why does the same query run faster the second time I run it?
43563
Speeding up the performance of write.table
67587
Fast way to discover the row count of a table in PostgreSQL
156181
How do completely empty columns in a large table affect performance?
143004
sys.dm_db_index_physical_stats is extremly slow
14326
Why is any pgr_* routing function taking forever based on OSM data in an pgrouting enabled DB
157000
Is there a nesting limit for correlated subqueries in some versions of Oracle?
95093
How does SQL Server's optimizer estimate the number of rows in a joined table?
93153
Optimizing SQL for large volumes
99497
IF EXISTS taking longer than embedded select statement
83030
Get counts of all tables in a schema
65713
Update by iterating table in batches faster than whole table in PostgreSQL
113095
How do I retrieve all tuples from similar tables in a postgresql database?
89905
Have I actually found a real bug in PostgreSQL?
130239
Optimise PostgreSQL for fast testing