Re: Please suggest me on my table design (indexes!) - Mailing list pgsql-general

Almost forgot: one fo the heavier select query can be:
-----
SELECT
    contact.id,
    contact.company_id,
    contact.name AS nome,
    contact.surname AS cognome,
    contact.email AS email,
    contact.company_name AS azienda
FROM
    contact
WHERE
    (
     lower(contact.company_name) LIKE 'smit%' OR
        lower(contact.name) LIKE 'smit%' OR
        lower(contact.surname) LIKE 'smit%' OR
        contact.phone LIKE 'smit%' OR
        lower(contact.code) LIKE 'smit%' OR
        lower(contact.email) LIKE 'smit%'
    )
ORDER BY
    contact.company_name ASC, contact.company_id DESC
-----
And this is the queyr plain: http://explain.depesz.com/s/Il