Re: Problem (bug?) wih like

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bombadil(at)wanadoo(dot)es
Cc: Lista PostgreSql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem (bug?) wih like
Date: 2001-12-03 14:43:01
Message-ID: 12824.1007390581@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

bombadil(at)wanadoo(dot)es writes:
> select * from v_A where name like '%DAVID%'

> It freezes psql.

I don't believe that it's really "frozen". Taking a long time, maybe.

> Why?

You tell us. What's the EXPLAIN query plan for these three queries?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yuri A. Kabaenkov 2001-12-03 14:55:54 interval
Previous Message Martijn van Oosterhout 2001-12-03 13:53:53 Re: which physical file does postgreSQL stores data?

Browse pgsql-hackers by date

  From Date Subject
Next Message Christof Petig 2001-12-03 14:46:56 TODO
Previous Message Horák Daniel 2001-12-03 12:32:25 Re: FW: [CYGWIN] 7.2b3 postmaster doesn't start on Win98