Select "segmented report are pre-processed" in the top option.

Setup: http://piwik.org/setup-auto-archiving/

Use Piwik 2.0 alpha from http://builds.piwik.org/

it should work

So you suggest using a Alpha Software for a productive System with over 2000 visitors per day? I hope this is a joke.
BTW: Auto archiving is activated, but that doesn't prevent segmented reports from crashing the server. What if somebody creates a new segment, auto-archive didn't run and he tries to select this segment?
This all doesn't prevent crashing the server.

Not a joke, it works quite well. I suggested because you had some urgent problem, so it definitely will not be worst (but keep a mysql backup to be safe)

well, my fast solution was du deactivate the segment editor. It looks like the fact, that the segment editor is a feature for killing the server is already obvious. So I'll have to wait for the 2.0 stable release and test again and check if the segment editor is no more a plugin in alpha state.

I think it's a bit unfair to say the Segment Editor is an alpha plugin. I have a site with about 30 000 pageviews a day and use a segment filtering 6 different IP without problem.

I'm lucky, Apache-PHP-Piwik is on a dedicated server and MySQL is on another, solely for Piwik work.

I'm not saying that it's perfect thought. There's always room for improvement.

Dali