Re: Query with "like" is really slow

From: "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Query with "like" is really slow
Date: 2007-09-07 15:01:29
Message-ID: fbrp3t$rdn$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<<Actually it's quite possible that
that extra overhead in nested loop is largely gettimeofday() calls for the
explain analyze. Does the query take less time run without explain analyze
than it does run with it?
>>

Do you mean that an EXPLAIN ANALYZE that runs longer than the actual query
is a symptom of time being lost to a function call?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-09-07 15:12:16 Re: Security Advances in Postgresql over other RDBMS
Previous Message Tom Lane 2007-09-07 14:31:10 Re: What's the difference between SET STORAGE MAIN and EXTENDED?