what I did, was an ANALYZE, which did not change anything. I just executed a VACUUM ANALYZE and now everything performs well. hm, strange.
thanks Dieter Am 12.04.2011 um 09:42 schrieb Claudio Freire: On Tue, Apr 12, 2011 at 7:20 AM, Dieter Rehbein <dieter.rehb...@skiline.cc> wrote: > Hi everybody, > > I have a performance-problem with a query using a LIMIT. There are other > threads rergading performance issues with LIMIT, but I didn't find useful > hints for our problem and it might > be interesting for other postgres-users. Did you perform an ANALYZE or VACUUM ANALYZE? Did you try increasing the statistic targets? AFAIK, it looks a lot like the planner is missing stats, since it estimates the index query on idx_nfi_newsfeed will fetch 10k rows - instead of 25. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
