postgresql-performance

31 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Adding OR clause to where condition is much slower than two individual queries
user_82153870
•
2
2
31
postgresql-performance postgresql sql
Is it wasteful to use ARRAY_AGG to get the first non-NULL value in a column?
user_917570
•
1
3
52
array-agg postgresql-performance greatest-n-per-group postgresql sql
Get minimum price from last 30 days and the last price before that, quickly
user_55800860
•
2
2
131
postgresql-performance timescaledb greatest-n-per-group postgresql sql
PostgreSQL: Underperforming query on large table with composite key
user_23234970
•
9
3
242
postgresql-performance amazon-aurora postgresql-12 postgresql sql
Identical SELECT vs DELETE query creates different query plans with vastly different execution time
user_68909080
•
2
2
66
postgresql-performance sql-execution-plan postgresql sql
Postgres Large table Optimal index selection for Select Query With In Clause
user_41671250
•
3
2
295
postgresql-performance postgresql sql
SQL statement timing out on large data set
user_61740650
•
2
2
68
postgresql-performance sqlperformance query-optimization postgresql
Query on json / jsonb column super slow. Can I use an index?
user_4393500
•
5
2
3158
postgresql-performance jsonb postgresql json
Getting top rows with the latest related row in joined table quickly
user_25642980
•
9
11
328
postgresql-performance postgresql-13 greatest-n-per-group postgresql sql
Optimizing SELECT count(*) on large table
user_11360660
•
1
1
296
postgresql-parallel-query postgresql-performance postgresql sql database
Hot Questions