thank's a lot guys, I will try that out.
regards
Dieter
Am 12.04.2011 um 11:07 schrieb Claudio Freire:
On Tue, Apr 12, 2011 at 10:59 AM, Dieter Rehbein
<dieter.rehbein@skiline.cc> wrote:
> I just executed a VACUUM ANALYZE and now everything performs well. hm, strange.
That probably means you need more statistics - try increasing the
newsfeed's statistics target count.
ALTER TABLE newsfeed_item ALTER COLUMN newsfeed SET STATISTICS <n>;
Try different <n> numbers, you can crank it up to 4000 or perhaps more
in 9.0, but you should start lower I guess.