Forgot to mention that our work_mem setting is 20480 Kb.
You might want to try
increasing work_mem for this one query to speed any sorting.
--
Igor Lobanov
Internal Development Engineer
SWsoft, Inc.
---(end of broadcast)---
TIP 5: don't f
updated? Clustering might buy you some
improvements (but not a huge amount I suspect).
It is updated once per 3-5 seconds.
And one more thing. I don't know if it helps, but column 'a' can have
value from a limited set: 0, 1 or 2. Column 'b' is also an
no effect, postgres simply ignores it, at least according to the
EXPLAIN output.
Is there any way to somehow improve the performance of this operation?
Table can not be changed.
--
Igor Lobanov
Internal Development Engineer
SWsoft, Inc.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster