Still getting a seq scan after doing vacuum analyze. Any other ideas?
2009/5/27 Grzegorz Jaśkiewicz :
> you have to vacuum analyze after you've created index, afaik.
> No, count(*) is still counting rows.
>
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make ch
>
> Preparing the query might actually hurt performance because postgres treats
> a prepare as "plan this query but I'm not going to tell you value of the
> parameters". If you actually let the query replan every time then you will
> get a different plan for the leaderbo
So Google hasn't been helpful and I'm not entirely sure what to look
for in the mailing lists to find the answer to my problem, so here
goes.
I have a query and I have run
explain analyze
select count(*)
from score
where leaderboardid=35 and score <= 6841 and active
The result is
"Aggregate (co
