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