Re: [GENERAL] Grant question

On Wed, Mar 2, 2011 at 2:30 PM, Michael Black wrote: > Ok.  What am I missing here?  B_USER is a defined Group Role > > CREATE ROLE "B_USER" >   NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE; > > > GRANT SELECT PRIVILEGES > ON b.config_itm > TO ROLE B_USER; > > Nets this --

Re: [GENERAL] SQL code runs slower as a stored function

> > It would help if you post the output from EXPLAIN ANALYZE for each case, > as this will hopefully show where the bottleneck is. > I'm glad you asked, and I think I've discussed enough about what *could-be* happening that I'd like to get my hands dirty with what's really going on. Maybe now I c

Re: [GENERAL] SQL code runs slower as a stored function

> I wrote a blog article about this: Google for "Why is my function > slow?" Greg, great article. It's funny and humbling how I thought I'd invented the wheel with this workaround, but now it suddenly appears to be common practice. I guess I'm

Re: [GENERAL] SQL code runs slower as a stored function

aw sql, but the raw sql wasn't what was running slow, so I'm not sure if it's even helpful to do that. Thanks! On Thu, May 13, 2010 at 12:06 PM, Stephen Frost wrote: > S G, > > * S G (sgennar...@gmail.com) wrote: > > Can anyone lend a guess as to what I'm runnin

[GENERAL] SQL code runs slower as a stored function

Hi all, It's my first time posting to the list, though it's helped me through numerous jams throughout the past year as I've been familiarizing myself with all of the wonderful postgresisms =) Just yesterday, I made what I thought would be a very minor and routine modification to a stored functio