On Thu, May 10, 2001 at 01:22:56PM +0000, ryan(at)paymentalliance(dot)net wrote:
> I vacuum every half hour! Here is the output from EXPLAIN:
>
> NOTICE: QUERY PLAN:
>
> Seq Scan on pa_shopping_cart (cost=0.00..7237.94 rows=9420 width=296)
>
> EXPLAIN
>
> Thanks!
Then try
set enable_seqscan to off;
explain select ...
and see what the cost is. Compare it with the value above.
Cheers,
Patrick