""Peter Krauss"" <[EMAIL PROTECTED]> wrote
>
> The single query (on psql) is fary fast
> (less than 1 sec)
>
> SELECT a,b,c,d FROM products_view WHERE
> sku='0-123-0-0-6024-20'
> OR lower(codfornecedor)=lower('0-123-0-0-6024-20')
> OR lower(eanfor)=lower('0-123-0-0-6024-20')
> OR lower(refprodfornecedor)=lower('0-123-0-0-6024-20');
> -- ~0.1 second
>
> BUT, IF I ADD a "LIMIT 1", it consumes 2 minutes!
>
> SELECT a,b,c,d FROM products_view WHERE
> sku='0-123-0-0-6024-20'
> OR lower(codfornecedor)=lower('0-123-0-0-6024-20')
> OR lower(eanfor)=lower('0-123-0-0-6024-20')
> OR lower(refprodfornecedor)=lower('0-123-0-0-6024-20')
> LIMIT 1;
> -- ~ 2 minutes !!
>
Can you post the \d of products_view and EXPLAIN ANALYZE results of these
two queries from psql?
Regards,
Qingqing
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
