Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group