postgresql-performance

31 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Why query in wrapped PLPGSQL function is much slower than itself?
user_54467340
•
2
1
385
postgresql-performance plpgsql query-optimization postgresql performance
postgreSQL slow query with high shared read
user_88661000
•
2
0
222
explain postgresql-performance postgresql-10 postgresql
Performance impact of view on aggregate function vs result set limiting
user_68706200
•
3
2
582
postgresql-performance sql-execution-plan postgresql sql performance
Pattern-matching for JSON values: slow EXISTS subquery on materialized view
user_1514610
•
2
1
664
postgresql-performance jsonpath exists database-design postgresql
Why optimization is not applied/different index is used?
user_46320190
•
2
2
51
query-planner postgresql-performance postgresql
Aggregate rows to get unique arrays without subsets
user_156542360
•
1
1
82
postgresql-performance concatenation merge postgresql sql
Index skip scan emulation to retrieve distinct product IDs and min/max for additional columns
user_47049760
•
3
1
1006
postgresql-performance database-performance query-optimization postgresql sql
SELECT DISTINCT is slower than expected on my table in PostgreSQL
user_47049760
•
7
1
2445
postgresql-performance database-performance query-optimization postgresql sql
Get values appearing at least N times in a table quickly
user_129254710
•
3
1
70
postgresql-performance greatest-n-per-group indexing postgresql sql
I need to add up lots of values between date ranges as quickly as possible using PostgreSQL, what's the best method?
user_16662760
•
5
1
56
postgresql-performance postgresql
Hot Questions