On Mon, Feb 23, 2009 at 6:54 PM, Sam Mason
<sam@samason.me.uk> wrote:
Depending on where these are on disk and how fast your disks are this
could take up to 30 seconds.
This does not sound very inspiring :-)
Would throwing more hardware (memory, faster CPU) at the server improve the situation?
If you want this sort of thing to go quicker you could try CLUSTERing
This can help because all other queries to this table alway filtered/grouped by context_id field. I will try that.
Thanks a lot, Sam!