Postgres Pro
Downloads
Home   >   mailing lists

Re: Query 4-5 times slower after ANALYZE - Mailing list pgsql-general

From Tom Lane
Subject Re: Query 4-5 times slower after ANALYZE
Date
Msg-id 14694.1237406382@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query 4-5 times slower after ANALYZE  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
List pgsql-general
Tree view 
"Philippe Lang" <philippe.lang@attiksystem.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

pgsql-general by date:

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