Re: select with "like" from another table

From: "chris smith" <dmagick(at)gmail(dot)com>
To: "Anton Maksimenkov" <anton200(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: select with "like" from another table
Date: 2006-05-29 10:36:43
Message-ID: 3c1395330605290336q5c894215ge28eea597626c781@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 5/29/06, Anton Maksimenkov <anton200(at)gmail(dot)com> wrote:
> Hi.
>
> I have 2 tables - one with calls numbers and another with calls codes.
> The structure almost like this:
...

How long does this query take?

SELECT code FROM a_voip_codes c, a_voip v where v.called_station_id
like c.code ||
'%' order by code desc limit 1

I wonder if you'll benefit from an index on a_voip(called_station_id)
to speed up this join.

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Markus Schaber 2006-05-29 11:11:13 Re: Getting even more insert performance (250m+rows/day)
Previous Message Anton Maksimenkov 2006-05-29 09:53:24 select with "like" from another table