On Fri, 2004-10-08 at 10:11 -0400, Tom Lane wrote:
> Robin Ericsson <[EMAIL PROTECTED]> writes:
> > -> Index Scan using idx_d_entered on data (cost=0.00..18024.04
> > rows=50360 width=16) (actual time=0.210..0.247 rows=1 loops=1)
> >Index Cond: 'now'::text)::timestam
Robin Ericsson <[EMAIL PROTECTED]> writes:
> The query have been running ok for some time now, but this morning I
> decided to run vacuum analyze (vacuumdb -a -z) on the cluster, and
> suddenly the query isn't running very well at all.
> -> Index Scan using idx_d_entered on data (cost=0
The query have been running ok for some time now, but this morning I
decided to run vacuum analyze (vacuumdb -a -z) on the cluster, and
suddenly the query isn't running very well at all. This query has only
one value in the "IN", if I add another id the query becomes really
really slow.
Query:
SEL
