Reputation
Top tag
Next privilege 50 Rep.
Comment everywhere
Badges
4
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Dec
3
awarded  Popular Question
Jun
25
awarded  Supporter
Jun
22
comment Slow ORDER BY with LIMIT
The query works. Turning the indexscan off works too. ANALYZE doesn't work. Thank you very much for comprehensive answer.
Jun
22
awarded  Student
Jun
22
awarded  Scholar
Jun
22
accepted Slow ORDER BY with LIMIT
Jun
22
comment Slow ORDER BY with LIMIT
Analyze didn't help. The table has about 36000 rows and I'm using postgresql 9.1.
Jun
22
asked Slow ORDER BY with LIMIT