On Mon, Feb 23, 2009 at 6:54 PM, Sam Mason <sam(at)samason(dot)me(dot)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!