Postgres Pro
Downloads
Home   >   mailing lists

Re: Query with "like" is really slow - Mailing list pgsql-general

From Carlo Stonebanks
Subject Re: Query with "like" is really slow
Date
Msg-id fbrp3t$rdn$1@news.hub.org
Whole thread Raw
In response to Re: Query with "like" is really slow  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Query with "like" is really slow
List pgsql-general
Tree view 
<<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?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: What's the difference between SET STORAGE MAIN and EXTENDED?
Next
From: Bill Moran
Date:
Subject: Re: Security Advances in Postgresql over other RDBMS