From: | gdh(at)eyjar(dot)is |
---|---|
To: | gdh(at)eyjar(dot)is |
Cc: | pgsql-performance(at)postgresql(dot)org, gdh(at)eyjar(dot)is |
Subject: | Re: Query slow after VACUUM ANALYZE |
Date: | 2005-08-31 10:26:22 |
Message-ID: | 1923.213.220.100.208.1125483982.squirrel@www.eyjar.is |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi again
[..]
>
> QUERY PLAN
> -------------------------------------------------------------------------
> Seq Scan on orders (cost=0.00..12184.14 rows=29526 width=33)
> Filter: (NOT (hashed subplan))
> SubPlan
> -> Seq Scan on orders_items (cost=0.00..0.00 rows=1 width=33)
>
> After the vacuum, the plan is like this:
>
> QUERY PLAN
> --------------------------------------------------------------------------------
> Seq Scan on fsi_orders (cost=0.00..40141767.46 rows=29526 width=33)
> Filter: (NOT (subplan))
> SubPlan
> -> Seq Scan on fsi_orders_items (cost=0.00..1208.12 rows=60412
> width=33)
>
This, of course, should be "orders", not "fsi_orders", and "orders_items",
not "fsi_orders_items". Sorry for the confusion.
Additional info: I'm running PostgreSQL 7.4.8.
Thanks,
Guðmundur.
From | Date | Subject | |
---|---|---|---|
Next Message | Brad Nicholson | 2005-08-31 13:51:43 | Re: 'Real' auto vacuum? |
Previous Message | gdh | 2005-08-31 10:22:44 | Query slow after VACUUM ANALYZE |