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!
On Thu, 10 May 2001 18:19:16 +0000 (UTC),
[EMAIL PROTECTED] (Stephan Szabo) wrote:
>
>Have you vacuum analyzed recently and what does
>explain show for the query?
>
>On Thu, 10 May 2001 [EMAIL PROTECTED] wrote:
>
>> Here's the query:
>>
>> SELECT
>> cart_row_id
>> FROM
>> pa_shopping_cart
>> WHERE
>> order_id = 20;
>> [ ... ]
>> There is an index on:
>> just order_id
>> just order_id and cart_row_id
>> and a PK on cart row_id
>>
>> I don't understand why it's not using one of these indexes!
>> Please post your responses to the group - my email is down.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
