Re: [PERFORM] Querying distinct values from a large table

2007-01-30 Thread Igor Lobanov
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

Re: [PERFORM] Querying distinct values from a large table

2007-01-30 Thread Igor Lobanov
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

[PERFORM] Querying distinct values from a large table

2007-01-30 Thread Igor Lobanov
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