> 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
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Patrick Hatcher||Date: 2003-06-27 19:09:50|
|Subject: Memory question|
|Previous:||From: Bruno BAGUETTE||Date: 2003-06-27 14:32:21|
|Subject: Large querie with several EXISTS which will be often runned|