> I will have to manage more or less 10.000 products with more or less 2-3
> options by products and more or less 40 options-groups.
> Do you think that this query will be hard for PostgreSQL (currently
> 7.2.1 but I will migrate to 7.3.2 when going in production environment)
> ?
> How can I improve that query to be faster ?

Collapse the inner EXISTS into a straight join in the outer EXISTS.  Since you 
are merely checking for existence, there is no reason for the subquery 

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to