Re: Slow index creation - Mailing list pgsql-general

From Michael Lewis
Subject Re: Slow index creation
Date
Msg-id CAHOFxGq9_7i_BjLhmCEu4TCugR6ktcMUtwhaYT431fE_6D9QBg@mail.gmail.com
Whole thread Raw
In response to Re: Slow index creation  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Slow index creation
List pgsql-general
https://www.depesz.com/2010/03/18/profiling-stored-proceduresfunctions/

Thanks for this reference. I enjoy your blog, but haven't made the time to read all the archives somehow. Stuff doesn't stick very well when it isn't yet "needed" info besides.

I have seen overhead from 'raise notice' in small functions that are sometimes called many thousands of times in a single query, but hadn't done the test to verify if the same overhead still exists for raise debug or another level below both client_min_messages and log_min_messages. Using your examples, I saw about .006 ms for each call to RAISE DEBUG with a client/log_min as notice/warning.

pgsql-general by date:

Previous
From: "Haas, Scott"
Date:
Subject: yum update for postgresql rpms
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Slow index creation