On Tue, 2005-03-15 at 18:10 +0100, Andreas Hartmann wrote:
> explain analyze select * from veranstaltung_original order by semester;
>
> Sort (cost=3054.08..3067.74 rows=5467 width=223) (actual
> time=2568.10..2573.02 rows=5467 loops=1)
> Sort Key: semester
> -> Seq Scan on veranstaltung_original (cost=0.00..2714.67 rows=5467
> width=223) (actual time=1936.68..2506.83 rows=5467 loops=1)
^^^^^^^
isn't this value (1936.68) suspiscious for a seq scan ?
can a lot of dead tuples cause this?
maybe VACUUM FULL ANALYSE time ?
gnari
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
