Re: Security definer "generated column" function used in index

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Security definer "generated column" function used in index
Date: 2011-12-20 22:02:46
Message-ID: 4EF0B1A60200002500043EC7@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> On reflection what seems most likely is simply that turning these
> otherwise-inlineable SQL functions into SECURITY DEFINER disabled
> inline-ing them, resulting in catastrophic degradation of the
> generated plans, such that they took a lot longer than you were
> accustomed to (they shouldn't have been "hung" though).

Ah, I had not considered that. That also explains why my attempts
to recreate the situation with "toy" tables didn't show the issue.
Also, it didn't occur to me until later to check whether a continue
and another backtrace showed things moving; all the evidence
suggested (in retrospect) that it was "doing something" rather than
being blocked, per se; but these are normally sub-second queries
which were killed after running over an hour, so I (probably
wrongly) assumed they were in an endless loop.

I will try again in just one site with a bit more care about which
functions I flag. If that goes OK, I'll have the confidence to go
forward with the application release.

Thanks!

-Kevin

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2011-12-20 23:56:07 Re: R: R: R: R: BUG #6342: libpq blocks forever in "poll" function
Previous Message Tom Lane 2011-12-20 21:53:19 Re: Security definer "generated column" function used in index