23 reputation
3
bio website
location
age
visits member for 1 year, 10 months
seen Jun 25 '12 at 13:42

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