Re: Strange query execution time

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Michel Soto <Michel(dot)Soto(at)lip6(dot)fr>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Strange query execution time
Date: 2001-07-10 21:36:03
Message-ID: Pine.BSF.4.21.0107101435460.93882-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


What does explain show for the two queries?

On Wed, 4 Jul 2001, Michel Soto wrote:

> Hi,
>
> Can someone explain why the following query takes 1 second when using
> LIKE and takes 30 seconds when replacing LIKE by = in the WHERE ?
> - instance_Attribute has 45 rows and Influence has 5 rows.
> - Postgresql 7.1

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-07-10 21:36:47 Re: AW: pg_index.indislossy
Previous Message Bruce Momjian 2001-07-10 21:34:51 Re: timestamp with/without time zone