R: R: slow seqscan after vacuum analize
От | Edoardo Ceccarelli |
---|---|
Тема | R: R: slow seqscan after vacuum analize |
Дата | |
Msg-id | 2s28b9$kqpdm@mailr-1.tiscali.it обсуждение исходный текст |
Ответ на | Re: R: slow seqscan after vacuum analize (Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>) |
Список | pgsql-admin |
> > AFTER (actual db) > > portaportese=# explain analyze SELECT * FROM utente where > luogorilasciodoc='ciao'; > > QUERY PLAN > > > > > ---------------------------------------------------------------------- > > ---------------- > > -------------------- > > Seq Scan on utente (cost=0.00..92174.50 rows=3 width=724) (actual > > time=705.41..6458.19 rows=15 loops=1) > > Filter: (luogorilasciodoc = 'ciao'::bpchar) Total > runtime: 6458.29 > > msec > > (3 rows After a VACUUM FULL ANALYZE: portaportese=# explain analyze SELECT * FROM utente where luogorilasciodoc='ciao'; QUERY PLAN -------------------------------------------------------------------------------------- -------------------- Seq Scan on utente (cost=0.00..41329.21 rows=154 width=724) (actual time=91.61..751.28 rows=15 loops=1) Filter: (luogorilasciodoc = 'ciao'::bpchar) Total runtime: 751.35 msec Things are better now! :) it surely was because i have used the normal vacuum...
В списке pgsql-admin по дате отправления: