Hi,
> In 7.4 a VACUUM should be sufficient ... or at least, if it isn't
Atfer VACUUM:
dps=# explain analyze select next_index_time from url order by
next_index_time desc limit 1;
QUERY PLAN
------------------------------------------------------------------------
------------------------------------------------------------------------
--
Limit (cost=0.00..2.62 rows=1 width=4) (actual time=0.098..0.099
rows=1 loops=1)
-> Index Scan Backward using url_next_index_time on url
(cost=0.00..814591.03 rows=310913 width=4) (actual time=0.096..0.096
rows=1 loops=1)
Total runtime: 0.195 ms
(3 rows)
dps=# explain analyze select next_index_time from url order by
next_index_time asc limit 1;
QUERY PLAN
------------------------------------------------------------------------
------------------------------------------------------------------------
-
Limit (cost=0.00..2.62 rows=1 width=4) (actual
time=13504.105..13504.106 rows=1 loops=1)
-> Index Scan using url_next_index_time on url
(cost=0.00..814591.03 rows=310913 width=4) (actual
time=13504.099..13504.099 rows=1 loops=1)
Total runtime: 13504.158 ms
(3 rows)
Better, but......
Cordialement,
Jean-Gérard Pailloncy