Re: ~* + LIMIT => infinite time?

From: <typea(at)l-i-e(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: ~* + LIMIT => infinite time?
Date: 2002-12-16 10:20:27
Message-ID: 64288.12.249.229.112.1040034027.squirrel@www.l-i-e.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>> I tested (part of) it on 7.3 , had to manually change ::int to
>> case-when-then-else-end as there is no cast from bool to int in7.3
>
> An upgrade to 7.3 has, in fact, gotten rid of that bug...

Damn. I spoke to soon. It *SEEMS* like it's back again. Very, very
strange.

If explain claims the "cost" will be ~1000, and then a query takes SO long
to return I give up and hit ^C, that's just not right, right? I mean,
that "cost" near 1000 may not be in seconds or anything, but 1000 is
pretty low, isn't it?

I give up for now. Need sleep.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2002-12-16 18:26:24 Re: ~* + LIMIT => infinite time?
Previous Message typea 2002-12-16 08:21:14 Re: ~* + LIMIT => infinite time?