> 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?
Yes, weird. Something was wrong in my own code, after I've rewrite it to
send you full sources of problem example, execution times of image
insertion and direct scaling function call became the same. Insertion of
4000x2667px (2MB) image and direct function call for downscaling
original image to 800x600px and 128x128px both takes 1.6 sec. Sorry for
confusion. And it is almost the same time that takes command line
utility to do the task. So, practically there is no overhead of using
triggers for such purposes.
Nevertheless here is my sources, maybe there is a better way to solve
In response to
pgsql-performance by date
|Next:||From: Gregory Stark||Date: 2009-02-18 13:44:23|
|Subject: Re: TCP network cost|
|Previous:||From: Rajesh Kumar Mallah||Date: 2009-02-18 09:03:48|
|Subject: Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller|