> 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
I do no, but you really need rescale the image when he comes to database? or
can you doing this after, in a schudeled job?
If you need resize the image en it comes, I believe you pay a price related
about performance because the this is working to save image, the toast
strtucture are receiving the
В Втр, 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 'original' and 'thumbnail'.
> > I've C-function defi
On Tue, Feb 17, 2009 at 12:46 PM, Alexander Gorban
wrote:
> В Втр, 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.
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 'original' and 'thumbnail'.
> I've C-function defined in *.so library and corresponding declaration in
> postgres fo
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
