Re: [PERFORM] Call of function inside trigger much slower than explicit function call

2009-02-18 Thread Alexander Gorban
> Well, that does sound weird... can you post the full definition for > the images_meta table? Are there any other triggers on that table? > Is it referenced by any foreign keys? How fast is the insert if you > drop the trigger? > > ...Robert Yes, weird. Something was wrong in my own code, aft

Re: [PERFORM] Call of function inside trigger much slower than explicit function call

2009-02-17 Thread Alexander Gorban
В Втр, 17/02/2009 в 12:24 -0500, Robert Haas пишет: > On Tue, Feb 17, 2009 at 11:17 AM, Alexander Gorban > wrote: > > Hi, > > > > I have table containing bytea and text columns. It is my storage for > > image files and it's labels. Labels can be 'origin

[PERFORM] Call of function inside trigger much slower than explicit function call

2009-02-17 Thread Alexander Gorban
Hi, I have table containing bytea and text columns. It is my storage for image files and it's labels. Labels can be 'original' and 'thumbnail'. I've C-function defined in *.so library and corresponding declaration in postgres for scaling image. This function scale image and insert it into the same