Re: Query 4-5 times slower after ANALYZE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Query 4-5 times slower after ANALYZE
Date: 2009-03-18 19:59:42
Message-ID: 14694.1237406382@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch> writes:
> A small question here: solde_po is an SQL function (not PLPGSQL). Is it
> "inlined" in the parent query before the whole query execution plan is
> calculated?

You should be able to tell that by inspecting the filter conditions
in the ANALYZE output. Do you see solde_po(), or its innards?

(Or in other words: it depends, and you didn't give us sufficient
info to say.)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message dfx 2009-03-18 20:15:31 How to configure PostgreSQl for low-profile users
Previous Message Greg Sabino Mullane 2009-03-18 19:57:57 Re: DBD::Pg`s $dbh->func( "/path/to/file", `lo_import` ) fails silently